DMax but less than

[bd528]

Hi,

I'm using the following in VBA :-

MaxVal = DMax("Sales_Ref","tblQuotesNew")

But how can I get the max Sales_Ref that is below 10,000?

Thanks in advance

 

[sneuberg]

MaxVal = DMax("Sales_Ref", "tblQuotesNew", "Sales_Ref < 10000")

 

[NauticalGent]

Steve...do you EVER sleep?

 

[bd528]

MaxVal = DMax("Sales_Ref", "tblQuotesNew", "Sales_Ref < 10000")

Thank you.

 

[sneuberg]

Steve...do you EVER sleep?

Actually usually too much. Last night for example I was in bed from about 8:00 PM to 5:20 AM. But my prostrate causes me to get up about seven times so it even seems longer.