If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I calculate this?
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 (orderdateValid from date))) How do I approach this? Quite new at Access so any help is usefull! |
#2
|
|||
|
|||
How do I calculate this?
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 "Fredrik" wrote: 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 (orderdateValid from date))) How do I approach this? Quite new at Access so any help is usefull! |
Thread Tools | |
Display Modes | |
|
|