How do I calculate this?

F

Fredrik

Hello!

I have four tables:

tblOrders
Orderno Orderdate Loadingplace Pallets

tblLoadingplaces
Loadingsplace Region

tblInboundCosts
Region Cost(per pallet) Valid from date

tblOilSurcharge
Index (1,05 etc) Valid from date

What I want to calculate in a query is the cost for each order.

I know what I want, but not how to do it.
This is my logical approach.
Pallets * (Cost/p (cost taken from the nearest date)) * (Oilindex (index
take from nearest date (orderdate>Valid from date)))

How do I approach this?
Quite new at Access so any help is usefull!
 
B

Bonnie

Hi Fredrik,

How are the tables related? You need something common in the tables to
relate them on. So if each table has an OrderNo field the same you can
relate them in a query and then run the calculation.

Bonnie
http://www.dataplus-svc.com
 

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

Lookup value, but between dates 6
How can I show missing matches within my query results? 1
how do i calculate the number of days until a certain date 1
can I do this in excel 6
Is this a bug or what am I missing? 4
How do I calculate and store results? 5
how do i calculate future date in excel 1
how do I calculate elapsed time in Access, I have start date/time. 7

Top