Query Building

Resolved · Low Priority · Version 2003

Tue 20 Oct 2009, 09:35 Delegate 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:49 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips