G
Guest
I am currently running a query which selects different
records according to criteria set. Three example fields
in this query are report due, report initiated and start
date. I would like the query to show all fields where it
is 30 days after the report initated date or all fields
where the start date is null or all fields where its been
30 days after the report due date. However having this
criteria entered my query only shows records that fulfill
all the criteria, how do should i resolve the problem? I
would rather not have a seperate query for each criteria
but will if it is the only way.
records according to criteria set. Three example fields
in this query are report due, report initiated and start
date. I would like the query to show all fields where it
is 30 days after the report initated date or all fields
where the start date is null or all fields where its been
30 days after the report due date. However having this
criteria entered my query only shows records that fulfill
all the criteria, how do should i resolve the problem? I
would rather not have a seperate query for each criteria
but will if it is the only way.