What type of Query

[Scott Duncan]

We are trying to design an Account History Query where the Debits are stored
in one Table and the Credits are stored in another table...

We want a chronological listing of Debits & Credits with a running total.

Not sure what type of query to use. We have used Union Queries in the past
but we have never used a Pass Thru.

Any advice would greatly be appreciated !

TIA,

Scott Duncan

 

[Duane Hookom]

You could use a union query as the record source of a report. Add a text box
to the report's detail section that has the Running Sum set to "Over All".

 

[Scott Duncan]

Thank you !

SD

You could use a union query as the record source of a report. Add a text
box to the report's detail section that has the Running Sum set to "Over
All".