Using outer join (1 Viewer)

[wgma]

I am using Access 2007.

I have 2 queries, q1 and q2, that return similar data just different date ranges. I need to be able to get all of the records in q2 that are not in q1.

I tried to use an outer join but that didn't work. How can I do this?

I have tried

Select q2.* From q2 Where q2.a NOT IN (Select q1.a From q1)

This seems to take forever.

Thanks!

 

[SOS]

I am using Access 2007.

I have 2 queries, q1 and q2, that return similar data just different date ranges. I need to be able to get all of the records in q2 that are not in q1.

I tried to use an outer join but that didn't work. How can I do this?

I have tried

Select q2.* From q2 Where q2.a NOT IN (Select q1.a From q1)

This seems to take forever.

Thanks!

Just use the Unmatched query wizard.