Hello. I have a database with the following tables:
Customers, Orders, and Payments
The Customers table has a one-to-many relationship with the Orders
table. The Customers table also has a one-to-many relationship with
the Payments table.
I am trying to create what I think is commonly called a ledger sheet.
This sheet simply shows the dollar amount of every order that an
individual customer has placed (debits) and every payment that the
customer has made (credits). It also shows a running balance. Entries
are shown in chronilogical order.
I am having trouble creating a report that would draw debits from the
Orders table and credits from the Payments table. I have had good luck
in the past using queries as sources for reports but I can't figure
this one out. I would like someone to tell me if I am structuring this
thing correctly and how to create the report I need. I would be happy
to supply any further info necessary. Thanks.

I'm not a guru as some here but I'll try.

you may need to check out what type of relationship you have in your query.
There's the deal with inner and outer joins that may help you understand how
to get orders without payments to show.

http://www.databasedev.co.uk/query_joins.html

Chris

"(E-Mail Removed)" wrote:

> Hello. I have a database with the following tables:
> Customers, Orders, and Payments
> The Customers table has a one-to-many relationship with the Orders
> table. The Customers table also has a one-to-many relationship with
> the Payments table.
> I am trying to create what I think is commonly called a ledger sheet.
> This sheet simply shows the dollar amount of every order that an
> individual customer has placed (debits) and every payment that the
> customer has made (credits). It also shows a running balance. Entries
> are shown in chronilogical order.
> I am having trouble creating a report that would draw debits from the
> Orders table and credits from the Payments table. I have had good luck
> in the past using queries as sources for reports but I can't figure
> this one out. I would like someone to tell me if I am structuring this
> thing correctly and how to create the report I need. I would be happy
> to supply any further info necessary. Thanks.
>
>