How do I build a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 26 May 2005 00:05 GMT

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

Reply to this Message

John Vinson - 26 May 2005 01:08 GMT

>Hello all,
>I'm trying to build a report which would look like a statement. I have all
[quoted text clipped - 5 lines]
>
>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]

Reply to this Message