Criteria question

jeo

Registered User.
Local time
Today, 09:22
Joined
Dec 26, 2002
Messages
299
In the query that is on the screen print there is criteria for start date and end date. I’m wondering if there is an operator between those 2 and what I mean by that - is there an AND or an OR?
startdate criteria AND enddate criteria or
startdate criteria OR enddate criteria

Thanks.
 

Attachments

One row (across) is AND
Second is OR with first row

You can look at the SQL to see what it is doing.

But basically it would be somthing like
(Row1Crit1 AND Row1Crit2 AND etc.)
OR
(Row2Crit1 AND Row2Crit2 AND etc.)
 
Thank you. I didn't even think about looking at it in SQL fromat.
Thanks!
 

Users who are viewing this thread

Back
Top Bottom