Comparing

[Mike]

HI,
I have 10 retail stores that i am over. I have made a mdb. to trak transfers
from store to store.
I need a way to compare [Store] to [Store To/From] if Qty Matches
Example of transfer in
[Store] [Store To/from] [Date] [PLU] [Plu Desc]
[Qty]
1 2 10/31/06 123456789 Desc
1
Example of transfer out
[Store] [Store To/from] [Date] [PLU] [Plu Desc]
[Qty]
2 1 11/01/06 123456789 Desc
-1
Please help

 

[John Vinson]

HI,
I have 10 retail stores that i am over. I have made a mdb. to trak transfers
from store to store.
I need a way to compare [Store] to [Store To/From] if Qty Matches
Example of transfer in
[Store] [Store To/from] [Date] [PLU] [Plu Desc]
[Qty]
1 2 10/31/06 123456789 Desc
1
Example of transfer out
[Store] [Store To/from] [Date] [PLU] [Plu Desc]
[Qty]
2 1 11/01/06 123456789 Desc
-1
Please help

Try creating a query by adding your table to the query grid TWICE.
Join [Store] in one table to [Store To/from] in the other instance of
the table; I'm not certain how your business logic works, but you'll
probably also want to join [PLU] to [PLU] as well, and perhaps [Date]
to [Date].

John W. Vinson[MVP]