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.
- 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 sales. I have also created a field which has concatenated by
division, store, and layaway #.

Thanks in advance.

 

[Jeff Boyce]

Are you saying that if something doesn't show up in either your first or
second query, you will consider it "open sales" (we don't know your
terminology)?

One approach might be to build a union query out of the two queries, then
build an unmatched query (have the query wizard in Access help on this)
between the union query and your full list/table.

Regards

Jeff Boyce
Microsoft Office/Access MVP