I have a table that has fields that are job no and operations. Each job No has a unique rate for each operation. The records are the rates for each job and operation. I need a formula in the query that will pop up the rate when i type in the job number and operation. The operation and job number will be different every time. So i need it to lookup up the job number and operation and find the coinciding rate. PLEASE HELP ME!!!!!!!!!!!!!

[This message has been edited by sassygirl (edited 03-07-2002).]

Can you be more specific? Does the job # have an associated rate or is the rate tied to the operation. If the rate different for every job # or operation, the most basic thing would be to add a text box for the rate and do the calculations within the form.

Remember, you can't give too much info when asking for help.

Search Help for the DLookup() function. This will allow you to find the rate that you need based on the job and operation.

Here is the rough syntax

Rate = DLookup("[Rate]", "TableName", "[Operation] = '" & Me![Operation] & "' And [JobNo] = " & Me![JobNo] & ")

[This message has been edited by Jack Cowley (edited 03-07-2002).]