SQL?

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

Guest

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.
 
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

brmk said:
I am creating an invoice. I need to lookup rates for the bill to
Click to expand...
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.
 
Look at the DLOOKUP function in Help.

It goes like:

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


Chris Nebinger
 
Back
Top