Heather has attended:
Access Intermediate course
Access Advanced course
Excel Advanced course
Access Advanced course
Query Building
I have a field in my Database with a number of sets of initials separated by commas. I want to run a query pulling out individual contact lists but it is only pulling out the records where each person is the sole contact and ignoring records where there are multiple sets of initials because there are other people who also know that contact.
For example I want all of CC's contacts
CC only in field - fine
AA BB, CC - record gets omitted from query results.
Thanks for any help with this
RE: Query Building
Hi Heather
Thanks for your question
If in the query Criteria row you type the following
*CC*
Then the query will return everything containing CC
The star symbol is known as a wildcard and basically means "anything". So the query will return any field that contains CC in any position.
One further observation. A field that contains multiple values contravenes the first normal form. Ideally you should place the contacts in a separate table.
Regards
Stephen
