98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Query Building
Query Building
Resolved · Low Priority · Version 2003
Tue 20 Oct 2009, 09:35Delegate Heather said...
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
Fri 23 Oct 2009, 09:49Trainer Stephen said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hide Access TablesOne method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys. |
