SQL?

[brmk]

I am creating an invoice. I need to lookup rates for the bill to customer. The actual field (Rate 1, Rate2, etc) depends on the weight entered by user. How do I look up the rates and then use the field value in a calculation.

 

[Nikos Yannacopoulos]

It would help a lot if you posted the rate table structure (with actual
table and field names) and some example records, as well as the names of the
controls on your form (weight, rate).

Nikos

I am creating an invoice. I need to lookup rates for the bill to

customer. The actual field (Rate 1, Rate2, etc) depends on the weight
entered by user. How do I look up the rates and then use the field value in
a calculation.

 

[Chris Nebinger]

Look at the DLOOKUP function in Help.

It goes like:

Dlookup("FieldName","TableName","WhereCondition")


Chris Nebinger