Dlookup & Max (1 Viewer)

I am trying to get a Dlookup function to pull one number from a table(trackopupdate). I want to give it a specific item and op(two fields in my table) and i want it to return the largest ID(autonumber) that exists in the table for that item and op.

here's what i have now:

RevRec = DLookup("Max([ID])", "TrackOpUpdate", "Item_Nbr = " & Item & "And Op_Nbr = " & op)

any help would be greatly appreciated...

-kermit

RevRec = DMax("[ID]", "TrackOpUpdate", "Item_Nbr = " & Item & "And Op_Nbr = " & op)

kermit,

You have duplicates in your table, this will make life tougher
for you.

I take it that in the set of records that share the same Item_Nbr
and Op_Nbr, the one with the highest number is the latest
"revision". If that's the case then you should add a revision
field.

However, with your current data, you can use the DMax function
to retrieve your highest value.

That might work for now, but your original design should
change. The AutoNumber fields should only be used to give
a unique identifier. They can't be "trusted" to convey info
such as the presence of the latest revision.

Wayne

hallo there ... I noticed you forgot to place the quotes "'" ...
try this ...

DLookup("Max([ID])", "TrackOpUpdate", "[Item_Nbr] = " & "'" & Item & "'" & " And [Op_Nbr] = " & "'" & op & "'")