get data from a table not in a query

[polparrot via AccessMonster.com]

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

 

[Dorian]

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]

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