ACCESS 2002 2

[Cia2a]

I want to extract only the records that meet certain criteria. I have a field "Priority" that has a look up for
1 Mission Critical
2 Mission Impact
and 3 others.
How do I write my query to extrapolate only one of these criteria.?

Thanks

 

[Hayton]

Try this.

Type "Mission Impact" or Mission Critical" or "..." etc,in the criteria section under the field which contains the data that you wnt to select from.

 

[bkpchs237]

cia2a,

This is a sample SQL statement for a query finding a value of priority =1 with a table name of Table3:
SELECT Table3.priority FROM Table3 WHERE (((Table3.priority)=1));

Hope this helps.

 

[Cia2a]

Thanks Gang that was superb.
Now how do I attach it to the report form?