How can I combine queries

[Ben2k]

If I have 4 queries all with the same fields but different criteria

How can I combine the 4 queries to return 1 datasheet with results from all 4

Ben

 

[Norie]

Ben

Depending on the criteria you could create one query that satisfies all your conditions.

Another way is to create a UNION query which is SQL-Specific.

 

[SydneyGeek]

As Norie said, try one query first. If each query only has one Criteria row, set up a new one that has the Criteria from each of your starting queries on a separate row. If that doesn't give the correct result, try the Union query.

Denis