Within a qry: TotalDropRate: [AmtofDrops]*[DropsRate]
The AMTifDrops column is manually entered value eg. 4
The DropsRate is from a lookup table.
Table is ID,Rate,Description. ID number is the auto number primary key.
eg.
ID Rate Description
1 $30
2 $40
3 $50
4 $60
The formula above is calculating on the ID number instead of the rate. So it is TotalDropRate: 4*3 = 12 Where I need 4*50=200
Any insight?? I am stuck.
Thanks in advance