Query Question

[herd]

I have a table with a records listed below. (Sample)

ID Date Finished Section Code
3 3/1/2004 Yes rmqe 2439
4 6/1/2004 No rmqo 2439
5 8/1/2004 Yes rmqo 2439
6 12/1/2004 No rmqe 2439
7 2/1/2003 Yes rmqe 2439
8 6/1/2004 Yes rmqo

I want to have make a query that will exract records with a Date <=3/1/2004 and Section "RMQO" and
Finished "Yes" or Code is not null

Gary

 

[alvechurchdata]

When you put conditions into the same criterion row of the grid they are ANDed together. You get an OR condition by using another line of the grid. The query will retrieve all the records which match either line of criteria.

Geoff Franklin

http://www.alvechurchdata.co.uk