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
|
|||
|
|||
get data from a table not in a query
Hi all.
I have the following issue: I have a query with the following tables: WCust, WFees, and RateType. The WCust contains customer name, address, etc., WFees contains vaious fees paid, and RateType contains 3 different rate types and the rates specific to each type. The RateType table stores rates for retail customers. If type "B" then 20rate = .75 and if type "T" then 20rate = 1.25. My issue is that the wholesale customer sells to both types "B" and "T". So when using a form called WCustFees and entering total cartons sold to type "B" customers it needs to calc the rate using .75 and like wise with "T" customers it needs to calc the rate using 1.25. Does anyone have any suggestions as to how to handle this. Polly -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
Thread Tools | |
Display Modes | |
|
|