Just checking

[aronw]

I wish to create a query that only displays the records that have a certain piece of text in a field. Query syntax is not my strong point.

I have an 'interest status' field which has about five options to choose from, one being 'top ten'. So how do I query all records where the interest status = "top ten"

I have simply written "top ten" in the criteria box. Is this right? The reason I ask is that i'm not sure it is showing all of the records
Any help would be greatly appreciated,

TIA

Aron

 

[ColinEssex]

Hi

What you've done is correct providing that the lettering and spaces are the same in the table. i.e "Top Ten" will not find the records with "Top Ten" (one has 1 space the other has 2 spaces)

Another way to check, if you've got too many records to count manually, is to do a quick count query based on your "interest status" field. This will not only make sure all the entries are consistent but will tell you how many to expect from your query.

Post back if you need further help

Col

 

[aronw]

yep

Thanks once again, thought so

Aron