Dmax

[kermit]

Heres what im trying to do:
I have a text box on a report and im trying to get a maximum number out of a table with specifications.
I am using DMax, but it keeps pulling the largest number in the whole table. I have tried many different alterations in my syntax, but i still cant get what i want to show up.
I am trying to get the maximum revision number based on the proper part_nbr and op_nbr.
Here is what my dmax statement is:

=DMax("Revision","TrackOpUpdate","[Part_Nbr]= " & Forms!parameterpass!Part_Nbr & " And [Op_Nbr]= " & Forms!parameterpass!Op_Nbr)

Any help would be greatly appreciated.
thanks
-kermit

 

[mark curtis]

Why dont you create a query for your answer and then a sub form linked on Part_Nbr?