G
Guest
Hello all...My problem is sort of a mix between Queries and Reports. I have
5 queries that generate data for 5 different reports. What I need is one
that summarizes everything. For example:
Checks/Wires Query pulls this,
$15,000
Payments pulls
$2,000
$3,000
Lockbox pulls
$30,000
$40,000
$50,000
I need to summarize all of this into one report to say the Total leftover is
$140,000. However, when I run this query, it is generating some strange
data. Here is a copy of my query.
Field: LeftOver LeftOver LeftOver LeftOver LeftOver
Table: Chks/Wires CollAgcy Lckbx MCare Payments
What it seems to be doing is this, for some reason it picked the number 48.
So for the checks and wires column, instead of pulling $15,000 once, it pulls
$15,000 48 times. For the payments column instead of pulling two records
($2,000 and $3,000) it pulls $2,000 16 times and $3,000 16 times and $0 16
times. It does the same for all the other columns.
Please Help!! Thank you all. I hope this was clear enough.
5 queries that generate data for 5 different reports. What I need is one
that summarizes everything. For example:
Checks/Wires Query pulls this,
$15,000
Payments pulls
$2,000
$3,000
Lockbox pulls
$30,000
$40,000
$50,000
I need to summarize all of this into one report to say the Total leftover is
$140,000. However, when I run this query, it is generating some strange
data. Here is a copy of my query.
Field: LeftOver LeftOver LeftOver LeftOver LeftOver
Table: Chks/Wires CollAgcy Lckbx MCare Payments
What it seems to be doing is this, for some reason it picked the number 48.
So for the checks and wires column, instead of pulling $15,000 once, it pulls
$15,000 48 times. For the payments column instead of pulling two records
($2,000 and $3,000) it pulls $2,000 16 times and $3,000 16 times and $0 16
times. It does the same for all the other columns.
Please Help!! Thank you all. I hope this was clear enough.