How do I build a query

[Guest]

Hello all,
I'm trying to build a report which would look like a statement. I have all
the purchased transaction's in one table, and all the payment transactions in
another table. In my report, i want to list both the purchased items and
payment transaction according to date.

How would i build a select record query for this?

Thank you

 

[John Vinson]

Hello all,
I'm trying to build a report which would look like a statement. I have all
the purchased transaction's in one table, and all the payment transactions in
another table. In my report, i want to list both the purchased items and
payment transaction according to date.

How would i build a select record query for this?

Thank you

You'll probably need a Report with two Subreports, one for items, one
for payments. Since we cannot see your table structure and have no
idea how they are laid out it's hard to be more specific than that. I
presume that both the purchase transactions and the payment
transactions are in a table (or tables) related one-to-many to some
Invoice table?

John W. Vinson[MVP]