..I just can't get a ( =Sum,Nz,Dsum )to work right.......

  • Thread starter Thread starter Popparod
  • Start date Start date
P

Popparod

....I based a report on a Sum of Payments Query......


SELECT DISTINCTROW Payments.MemberID, [AFBA Members].[First Name], [AFBA
Members].[Last Name], Payments.PaymentAmount, Sum(Payments.PaymentAmount) AS
SumOfPaymentAmount, Payments.PaymentDate, [AFBA Members].CardsIssued,
Sum([AFBA Members].CardsIssued) AS SumOfCardsIssued
FROM [AFBA Members] RIGHT JOIN Payments ON [AFBA Members].MemberID =
Payments.MemberID
GROUP BY Payments.MemberID, [AFBA Members].[First Name], [AFBA
Members].[Last Name], Payments.PaymentAmount, Payments.PaymentDate, [AFBA
Members].CardsIssued;


.....The Query works Great.......!

......But the Report...thats a different story.....

.....I get a running total "inside" the detail of the report....but never in
the footer......

.....When I put the Sum in the footer.....it shows $10.00.....I even went
back thru the table and changed
all the blank cells to $0.00.....

.....Members pay "$10.00"....Issued "1" card....

.....I'd kind of like a total of CardsIssued - PaymentAmount

....I've tried...=Sum([PaymentAmount])......Nz([PaymentAmount],0)...

........DSum([PaymentAmount]).[Payments]...? (something like that)....

.....I've done so many I'm about to be Coded Myself....."RED"

.......I'd sure appreciate any help you can give me.....I follow all the
threads and try everything....!!!!
 
I'm not sure why you would both Group By PaymentAmount and
Sum(PaymentAmount)?
Are you placing your totals in the group or report footer or are you
attempting to total in the page footer?
 
....to tell you the truth.....I just don't know anymore.....!

......I've put stuff everywhere to get it to work..........

.....I guess what I'm looking for is something like:...

......Name........PaymentDate......PaymentAmount...........CardsIssued.....

Member
1......04/04/04....................$10.00.......................1...........
.....
Member
2......12/02/04....................$10.00.......................1...........
.....
Member
3......01/14/04....................$10.00.......................1...........
.....
Member
4.......09/23/04....................$10.00.......................1..........
......
 
If what you are showing is the datasheet view, then you should be able to
place text boxes in your Group or Report footer with control sources like:
=Sum(PaymentAmount)
and
=Sum(CardsIssued)
 
........I got it to work at the End of the Report.....I'll deal with
that......

......it's funny though.....I've done everything from the "Helps"....the MVP
help Pages....
with learning Code and how to change the color of the text box on a form you
type
in ....hell...I'm even gettin' good at Queries....but this....?

.....bugs me because I've seen it done....

.....I'm sure glad people like you are there cuz the actual Help files leave
something to
be desired.....Thanks a bunch.....!!!
 
Back
Top