homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Business VS Individuals determination
Business VS Individuals determination

 4:02 pm on Aug 30, 2005 (gmt 0)

I have an Access Database with a table in it containing "Full Name". This full name could be either a first and last name of an individual or it could be a business name. Is there an access query or module that I can use to determine from the name if they are a business or an individual by the number of spaces or anything like that?




 4:26 pm on Aug 30, 2005 (gmt 0)

Why not have a marker in the database which will be set to determine whether or not this is the case?


 9:04 pm on Aug 30, 2005 (gmt 0)

Idealy I would like First, last, business, title, etc.. all split out. and field for BUS or HOM customers. But I am working with some unclean data and need to clean it, so to speak. Once it's clean I will be adding the marker, as you say.

I thought there was an access module or something like that which would go through each line and tell you if it has more than one space then it's a business, etc. I know it probably wouldn't cover 100% but I need at least 90%.


 2:36 pm on Aug 31, 2005 (gmt 0)

In Access you can do this with Len,Replace & IIF.

SELECT FullName, IIF( Len(FullName) - Len (Replace(FullName,' ','')) >1 , 'YES','NO') AS IsBusiness FROM Names

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved