Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Query Building
|
|
|
Bookmark this page|
The UK's most regular 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. |
Query Building
Resolved · Low Priority · Version 2003
Reply
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
For upcoming training course dates see: Pricing & availability
RE: Query Building
Hi HeatherThanks 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
|
 |
|
» Forum post: Atttachments |
Is there are size limit to atttachments
