Rod-
I assume that each Payment record has a Billing_ID, correct?
You can't do that in a query because you will see the related billing_amount multiple times if there are multiple payments for that billing. You can do it in a report by setting the Hide Duplicates of the Billing_Amount text box to Yes.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Sep 24, 2015, at 4:15 AM, desertscroller@cox.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have three tables with a common field define in table one (ID), the second table list all the billings for the individual defined by ID. Each billing has a unique id (Billing_ID). The third table identifies all payments the ID individual has made. The payments have a unique id (paid_ID) which is associated to a particular billing and the date of the payment. My issue is trying to develop a query that will display each individual records such as : (sort will be by ID, billing_id, Ascending date_of_payment)
1st record
ID billing_id billing_amount payment_id payment_amount date_of_payment
2nd record
1st record
ID billing_id billing_amount payment_id payment_amount date_of_payment
2nd record
ID billing_id payment_id payment_amount date_of_payment
so on
That is for a billing_id the billing_amount is only listed for the earliest date. Each new ID and billing_id will display as shown.
I know this may not be very clear. The query records will be used in a report form and also be allowed to export to EXCEL.
Any suggestions on the approach would be a great help.
ACCESS 2010 on WIndows 10 and Windows 7.
Rod
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar