Printing Query Results

  • Thread starter Thread starter Chris Peikert
  • Start date Start date
C

Chris Peikert

If you have multiple Contacts in your database, and each contact can have
multiple receipts for something.....How can you build your query to only
bring up and print a receipt for just that one contact who has made a
payment? For instance John Doe owes $5000.00. He has just made a payment of
2500.00 so he needs a receipt. After you take his payment you want to hit a
button that says print and it will run your query and print the results only
for that one contact. If he has made multiple payments it needs to show the
sum of the payments and the balance. Currently when I run my query it shows
the correct information except it does it for ALL Contacts instead of the
person im working on.
 
Chris,
You should have a form that allows you to enter the information about the
Contact, Ther items, and the transaction amounts... and that form should
have a unique identifying number for every record. (ex. frmPurchases with
"key field" PurchaseID)
Your receipt is a report with a query as the recordsource. Your query
for the report should filter out all other Purchases but the one that is
active on the "open" frmPurchases.
(example names... use your own_
In the PurchaseID field of your query for the report, a criteria of...
=Forms!frmPurchases!PurchaseID
causes the report to only return the information "unique" to that
PurchaseID, and no others.
hth
Al Camp
 
Back
Top