Duplicate record

[mabyn]

I have a database that has 4 fields.
Company Name Date Registration Fee Amount
Paid
Company A 1/1 $100
$100
Company B 1/9 $100
$50
Company C 1/13 $250
$250
Company D 1/20 $100
$100
Company B 2/1
$50

This data comes from three separate tables and I have it now in one query
called Payments. What is currently happening is the Registration Fee is
showing up every time a new payment is made, making my total registration
fees sum incorrect. I need it to appear as I have it above. (My real report
has many more fields than this. I am doing this to understand what I'm doing
wrong.) I think of it as duplicating the Registration record. I couldn't find
anything with that search criteria on the newsgroup. Thanks.

 

[Duane Hookom]

You can create a total query "making my total registration fees sum". Add
this query to your report's record source and display it in your report
footer.