What type of Query

S

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
 
D

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".
 
S

Scott Duncan

Thank you !

SD

Duane Hookom said:
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".
Click to expand...
 
Top