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 |
#2
|
|||
|
|||
get data from a table not in a query
You have not explained very well. You say "I have a query" but you don't say
what the query does. You need to post the complete SQL of the query. What table is your form bound to? -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "polparrot via AccessMonster.com" wrote: 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 . |
#3
|
|||
|
|||
get data from a table not in a query
Thank you Dorian for responding.
I just found one problem I was having with the query and that led to me answering my own issue. Everyone have a great day. Polly -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|