Saturday Help -- Max Function (1 Viewer)

[Randix]

Simple question...I have a table that has a field called "Control_num" that is defined as a number. There's another field in the same table that has a field called "tr_num". Upon entering the "tr_num" field, I simply want the highest number that appears in any of the records in the "Control_num" field to be placed in the "tr_num" field. I tried using the Max function by going Me!tr_num = Max(control_num) but i get the error message, "sub or function not defined"...i realize this must be simple, but can someone give me a clue...? Thanks

 

[Jack Cowley]

I think you are looking for the DMax function. Search help for DMax and I think you will find your answer there...

 

[Randix]

Jack...thank you, works fine. Have a great weekend.