How do I calculate this?

  • Thread starter Thread starter Fredrik
  • Start date Start date
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!
 
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
 
Back
Top