Search results for query: *

Could you suggest the best possible way to populate this table. I would like to do it like I wrote above.... Click on form bring up form for tbl_Cities CityId AutoNumber CitiesList Text CountyList Text Interested Yes/No choose this Contacts Interests... but then how do I get the form to...

So what I gathered from this data.. (thanks by the way) I need it to appear like: ContactID CityList (or) CityId 1 Allen Park 1 1 Belleville 4 1 Berkley 5 1 Beverly Hills 6 2...

ok so I need to build another make table that is populated like ContactID Number CityID Number Which data will appear like ContactID CityID 1 1,4,5,6 2 6,15,17,24 (or) ContactID Number CityList Memo ContactID CityID 1 Allen Park, Belleville...

Also I am not so VBA and SQL savy... I usually can figure it out... with baby steps... Again thank you for your patience.

My original table is Contacts: Contacts ContactID AutoNumber FirstName Text LastName Text CityLists Text (there is a lot more data...) When in form: (direct link) Contacts there is a tab controls... called General, Calls, Additional Info. In the Additional Info tab there is...

My apologies... You are exactly right... ID Numeric CityName Text Interested Y/N :)

Hi there Duane, I am also using your Concatentate Function and am having trouble. What I am trying to do: I have a form pulling up the table, personel will be talking with clients to find out what cities they are interested in and using a check box to update the table. CitiesList...

What if you have City State Zip + 4? I have some City State Zip and some Zip+4 the format is: ALLEN PARK MI 48101 (no commas) and ALLEN PARK MI 48101-1012 (no commas) I only want the City (ALLEN PARK) portion how do I do this without counting from the left or right for many Cities in my dbf...