Find the highest value in a column

[Tezzies]

Dim x As String

x = DMax("[Main_Table]", "Job No")

My error message says Job No can't be found.



Any ideas

Cheers

Phil

[CreganTur]

It's probably because your field name has a space in it (this is not a good design decision). Whenever a field name has a space in it you need to wrap it in brackets. So try this:

Dim x As String

x = DMax("[Main_Table]", "[Job No]")