Reading a column in a table based on a value

[Guest]

Hello. I have a table that contains shipping rates based on weight and
quantity. The left column is called "weight" and lists all the wieght
ranges. For instance, if the pakage weighs 0.38 pounds, you would look at
the prices on the line that read "0.40" pounds. The rest of the columns each
have a label that is a quantity. For example, for up to 50,000 pieces, you
would look at the column labeled 50,000. For a quantity from 50,001 -
250,000, you look at the column labeled 250,000. the other 3 columns are
labeled 500,000, 1,000,000, and 3,000,000. How do you make a report that
will select the correct quantity column in order to obtain the right shipping
rate? For example, if you have 700,000 pieces to mail and the piece weighs
0.40 pounds, how do you make the report look at the rate listed in the
1,000,000 column? Thanks for any help.

Brian

 

[Joseph Meehan]

Hello. I have a table that contains shipping rates based on weight
and quantity. The left column is called "weight" and lists all the
wieght ranges. For instance, if the pakage weighs 0.38 pounds, you
would look at the prices on the line that read "0.40" pounds. The
rest of the columns each have a label that is a quantity. For
example, for up to 50,000 pieces, you would look at the column
labeled 50,000. For a quantity from 50,001 - 250,000, you look at
the column labeled 250,000. the other 3 columns are labeled 500,000,
1,000,000, and 3,000,000. How do you make a report that will select
the correct quantity column in order to obtain the right shipping
rate? For example, if you have 700,000 pieces to mail and the piece
weighs
0.40 pounds, how do you make the report look at the rate listed in the
1,000,000 column? Thanks for any help.

Brian

Set up a query with the filed(s) you want to see and the field you want
to use a a criteria.

In design mode type a "?" without the quotes on the criteria line in the
field you want to find on. Then just run the query, it will ask for the
amount and find the matching records. You can base a form on the same
query.