Max value

[Super Suarez]

Hi

I'm trying to do a sect statement and put it in a variable which i can then output to a text box. How do I get the value into a variable? I can't seem to get my syntax right

this is what I currently have


Maxvalue = "SELECT MAX[Record Num]FROM Joblog"

 

[Mihail]

Use DMax() function for that.
MaxValue = DMax("Record Num", "Joblog")
Hope that you will have not troubles with that space in the field name. Why you not use RecordNum as name ?

 

[Super Suarez]

Thanks,

This is how it worked for me:-

MaxValue = DMax("[Record Num]", "Joblog")