get data from a table not in a query
in [Form]
|
From: polparrot via AccessMonster.com on 26 May 2010 10:58 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/Forums.aspx/access-forms/201005/1
From: Dorian on 27 May 2010 16:28 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/Forums.aspx/access-forms/201005/1 > > . >
From: polparrot via AccessMonster.com on 27 May 2010 20:41 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
|
Pages: 1 Prev: Routine to run/export queries Next: Set Query Criteria thru Function |