If any of the following are true

[Steven.Allman]

I need to set up a query that will look at A, B, C, and D, and then giv eme results if ANY of those are true

simple date fields with <Date()-30 code in criteria
however, all 4 date fields need queried.
I tried to set up 4 seperate queries, then have a new query look at those 4 for input, but that didnt work. Each individual worked great, but the 'master' wouldnt pull any information at all..

[ajetrumpet]

what was the sql for each individual query?

[Steven.Allman]

SELECT [Positive Packets].[1st Pos Notification Date], [Positive Packets].[Case Number]
FROM [Positive Packets]
WHERE ((([Positive Packets].[1st Pos Notification Date])<Date()-30));

That is the SQL to display the records from that field that are older than 30
then the other query's have the same language replacing 1 for 2,3,4 etc.
Each one works alone just fine.
From there I created a 5th Query, to combine the results from the other 4 to one table, and I get SQUAT.

[weekend00]

seems I am too late

[Steven.Allman]

All this information is coming from one table.
The tables have a
first contact
second contact
third and fourth, etc

I would like ONE query to look at all four columns in the table to return ALL records that meet any ONE of the 4 criteria.
Its easy to make it return something that meets all FOUR, but I want it to show me ALL that meet ONE....
What is wrong with the code I have entered?

SELECT [Positive Packets].[1st Pos Notification Date], [Positive Packets].[Case Number]
FROM [Positive Packets]
WHERE ((([Positive Packets].[1st Pos Notification Date])<Date()-30));

the master query that should look at all 4 sub querys has this code
SELECT [1st notification].[1st Pos Notification Date]
FROM [1st notification];
Right now I cant even get it to return results from ONE other query so I havent come close to trying all 4

[ajetrumpet]

seems I am too late

It's not a race weekend. It would be if we were being paid.

[weekend00]

But I was saying it's lack of information to provide help after steven had provided more details.

[Steven.Allman]

ok, oddly I have gotten it to work. Not sure what I have done. However, its not correct.
I need each one in a new record, as of now, its combining records.
If record 1 meets criteria A, and record 2 meets criteria C, then the query created a result with ONE record with both fields full....
POOOOOOOP