How do I create a Profit Report from one-to-MANY relationship?

J

jhunter

=====
ISSUE
=====
What's the best way to create a profit report, in a one-to-MANY
relationship, where fields in both tables have numbers to be
calculated?


============================
REPORT SHOULD LOOK LIKE THIS
============================
Date Client Inv# Profit
1/1/2005 AT&T 12345 $100
1/2/2005 AT&T 12346 $50
1/3/2005 eBay 12345 $75
====
Total $225



======
TABLES
======
Sales
SalesDetails


====================================================
FIELDS TO BE CALCULATED (and which table they're in)
====================================================
Cost (SalesDetails)
List (SalesDetails)

Freight (Sales)
FreightCost (Sales)


=====
NOTES
=====
In English, I need to take all the line items of a sale (from the
SalesDetails table), calculate the profit of each, then add freight
(which is in the Sales table) then subtract freight cost (which is also
in the Sales table).

Everything else about this database/program is setup and has worked
great for 3-4 years.


==========
BACKGROUND
==========
O/S = W2kPro
Patches Installed

Software = Access 2000
Patches Installed


=========
Thanks!!!
THE END
=========
 
M

Michael Kintner

First doa crosstable query again the profit table.

Then report on the crosstable query and it will auto group by name and give
totals.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One to many relationship 4
Relationship with a Primary Key? 4
Report Issue - one-to-many table relationship 1
Many to many relationship issue 4
Copying records from the "many" end of a relationship to a new ID on the "one" end 2
Issue with report - one-to-many relationship 5
Implementing a many-to-many relationship 4
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5

Top