Help With Criteria in Query

F

Fandaz

Quite simple. I want to display two types of records from a field. Example :-
My field has Rolex, Omega, Tudor and Tag, I want to extract only Rolex and
Tag.
In the criteria box what do I put in there. I thought it would be LIKE
"Rolex" AND "TAG" or maybe "Rolex" AND "Tag"
But it wont work. Can anyone help and/or point me to a good site so that I
can learn these SQL statement thingys......Thanks in advance for anyone that
helps.
 
W

Wayne-I-M

"Rolex" Or "Tag"
in criteria row

or

SELECT TableName.PrimaryField, TableName.FieldName
FROM TableName
WHERE (((TableName.FieldName)="Rolex" Or (TableName.FieldName)="Tag"));
 
F

Fandaz

Wayne you are a hero.......Thanks for reading and responding.....Do you know
of any good sites or books that can help with these kind of issues?
 
W

Wayne-I-M

You could try here for a start

http://www.mvps.org/access/queries/index.html

Not sure about books. The only ones I have are the standard (think you
should be able to get them from Amazon)

Using Access
ISBN 0-7897-1606-2
and others like this.

I think someone else may answer this post with better books and ideas.
Sorry can't be much help with this but I am OK with speaking and "slow"
reading in English but still would have problems with getting to much info
from a book.
 
Top