Comparison Query

[txgeekgirl]

I need help with a comparison query -

Two tables [ClientTime] & [EncTime]

Fields for Cost_Center, ClientNo, SvcCode, SvcDate, SvcDur.

ClientTime has 374 records. EncTime has 50.

I need to peel off those 50 from ClientTime. I have tried a simple join for Cost_Center, ClientNo, and SvcCode where CTServDur<>EncServDur.

I end up with dupes.

I did Outer Joins on those three - same results.

I know it's something simple... Any hints???

 

[David Eagar]

run query as Group by?

 

[txgeekgirl]

Where all the fields are grouped?

I have the two feeder queries Grouped on every field except Duration (summed).

 

[txgeekgirl]

I figured this out - switched to SQL - something I am comfortable in and qrote the query the way I wanted it and then switched back into Access and saw how their design query handled it. Adds three columns on the end with my IsNull statements from my SQL where clause, then sets Criteria in the row.