Query - Report Glitch

[lljpdx]

I have a transaction # for each record in my main form with a subform
"Approvals" and "Checkouts".

I created a query to show the sum of all Approvals and all Checkouts by
Transaction # for each record. (one for Accruals and one for Checkouts).
All approvals and checkouts come up in these queries.

I want to create a report showing, per Cost Center, the $ amt of Approvals,
the $ amt of Checkouts, and a calculated field to show the remaining value.

The report comes up with all approvals and checkouts per cost center,
however, if there is an approval that does not have a checkout associated
with it yet, the approved amt will not be shown in the cost center total. It
looks like unless there is an approval and checkout both, the record is
ignored.

How do I show all approvals even though a checkout may not exist yet? I'm
thinking that the Approval ID and Checkout ID autonumber fields should maybe
be associated with the Transaction # for that record (or Cost Center)?

Any help is much appreciated.

 

[lljpdx]

Also posted this question in queries... may fit that catagory better...