G
Guest
Access 2002 o/s WinXp
I have a Case Receipts Report based on an Invoice query that I have setup to
calculate monies received on a monthly basis.It contains the fields in the
invoice query based on the fields of the invoice table.
I need to enter the name of the client from 2nd Table (cases table), but
keep getting duplicate records when I add the cases table to the mix.
Both tables have a record case# that have a interegrity relationship.
The cases table comprised of clients, a record for each client has a #; the
invoice has the same client #.
Invoice is a sub form of main client form.
Please help! Thanks.
I have a Case Receipts Report based on an Invoice query that I have setup to
calculate monies received on a monthly basis.It contains the fields in the
invoice query based on the fields of the invoice table.
I need to enter the name of the client from 2nd Table (cases table), but
keep getting duplicate records when I add the cases table to the mix.
Both tables have a record case# that have a interegrity relationship.
The cases table comprised of clients, a record for each client has a #; the
invoice has the same client #.
Invoice is a sub form of main client form.
Please help! Thanks.