table normalization and parametr query - john vinson pls replyyy

[rekha]

Hello John,

Could you please helpme...kindly give me an example as to how one should get
the table right ...

thanks in advance.

Hello!

I have a table that has rates based on weights of goods, which is
catagorized as rate1, rate2...rate6, based on weight codes which are
1,2,3,4,5,6.

Let me get this straight - do you have *SIX FIELDS* named rate1 to
rate6? If so, your table structure is improperly normalized. You're
embedding a one-to-many relationship in each record, instead of
correctly having a one-to-many relationship to a Rates table.

I want to accept a number ranging from 1 to 6 from the user, who should have
an option to enter his choice of weight every time the query runs and get
rates pertaining to that record (corresponding to that weight only.)

pls help me - how do you accept a choice from user.

With a Parameter query.

also how do you select records based on the weight code, which extracts only
the corresponding rate.

With a fair bit of difficulty in your current table structure; with a
simple parameter if you have the structure correctly normalized. With
your current design, as I understand it, you would need a monstrous
Choose() function:

Rate: Choose([Enter weight code, 1 to 6:], [rate1], [rate2], [rate3],
[rate4], [rate5], [rate6])


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps