Select Queries

[Mike]

I have two select queries:
- one query with fields that contain division, store, layaway #,
line name (which has whether it was a deposit, markdown, tax) and amount, but
I have in the criteria to bring me back only the deposits (customer payments).
- the other query has the same fields but I have it bringing me back
all of the returns (RTS) in the line name.

I want to create a query joining these select queries together, that way Im
left with open layaways. A layaway may have deposits listed from a customer,
however, if it has a corresponding RTS, then it is considered a close
layaway. I have also created a field which has concatenated by division,
store, and layaway #, that way I can sort of match the layaways up?

Thanks in advance.

 

[Jeff Boyce]

Did you try creating a UNION query?

Regards

Jeff Boyce
Microsoft Office/Access MVP