how to lookup a value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables that I am trying to get acess to calculate. However the
amount is based on different criteria. I have searched but I find nothing
here on in my library that tells me how to do this. I would prefer to write
the formulas in a query rather than a form if that's possible. The query is
based on a table with the customers "code" and their state.

Examples would be:

State Food Clothing Other
AK 5% 5% 0%
AL 0% 4% 0%
AR 9% 9% 9%
AZ 2% 5% 6%


Discount 0-$500 $500-1000 Over $1000
Code1 5% 7% 10%
Code2 3% 5% 7%
Code3 2% 3% 5%
Code4 0% 2% 5%

Any and all help would be much appreciated.....I am stumped!
 
I have two tables that I am trying to get acess to calculate. However the
amount is based on different criteria. I have searched but I find nothing
here on in my library that tells me how to do this. I would prefer to write
the formulas in a query rather than a form if that's possible. The query is
based on a table with the customers "code" and their state.

Examples would be:

State Food Clothing Other
AK 5% 5% 0%
AL 0% 4% 0%
AR 9% 9% 9%
AZ 2% 5% 6%


Discount 0-$500 $500-1000 Over $1000
Code1 5% 7% 10%
Code2 3% 5% 7%
Code3 2% 3% 5%
Code4 0% 2% 5%

Any and all help would be much appreciated.....I am stumped!
Click to expand...

What is it that you are trying to calculate??

If you create a Query joining the customer table to the first table by
their state code, you'll have the Food, Clothing, and Other fields
avaialable for anything you want to do with them; similarly with the
Discount table.


John W. Vinson[MVP]
 
Back
Top