C
Cyndi
I have an access database that is very comprehensive and very complex
to track stallions on a horse farm. This was not written from an
accountants view point so I have imported the tables that I need and
made a couple of my own and have written queries and forms to do the
accounting info I want. I am now working on the report - this is a
very comprehensive report that comes from several of their tables and
several of my tables. As I add the fields to the query I begin in
their tables and with changing some joins the info is there just like
I want it but when I go to add the accounting info from my tables the
mare name will be there twice - so for example Mare named Shelley -
owned by x and b in the 1st tables she is there with both owners and
the correct charge Shelley x $10000
Shelley b $5000
- when I add my table to show the payment she shows up 4 times -
Shelley x $10000
Shelley b $5000
Shelley x $5000
Shelley b $10000
in my payments table there is only one payment posted for each partner
- if I do a query of the payments table it only shows up once - but If
I put this query in another query she shows up 4 times - can anyone
please tell me what is going on??
All help is greatly appreciated.
to track stallions on a horse farm. This was not written from an
accountants view point so I have imported the tables that I need and
made a couple of my own and have written queries and forms to do the
accounting info I want. I am now working on the report - this is a
very comprehensive report that comes from several of their tables and
several of my tables. As I add the fields to the query I begin in
their tables and with changing some joins the info is there just like
I want it but when I go to add the accounting info from my tables the
mare name will be there twice - so for example Mare named Shelley -
owned by x and b in the 1st tables she is there with both owners and
the correct charge Shelley x $10000
Shelley b $5000
- when I add my table to show the payment she shows up 4 times -
Shelley x $10000
Shelley b $5000
Shelley x $5000
Shelley b $10000
in my payments table there is only one payment posted for each partner
- if I do a query of the payments table it only shows up once - but If
I put this query in another query she shows up 4 times - can anyone
please tell me what is going on??
All help is greatly appreciated.