How to select biggest value in a field in a Query?

[mrchonginhk]

I have a table with a field called Sales like this

City, sales
============
City1, 100
City2, 200
City3, 50

What query can select 200 ?
I tried select Max(Sales) from TableA and it failed.

Help...

 

[bobinnc]

If your query returned a value of 50, it is most likely that you defined the "Sales" field as text. You can either redefine it as a number, in which case your query should not work. Or you can change your query to evaluate the value of the text field using Max(Val(Sales))

 

[Norie]

If you want the maximum sales and nothing else use DMax.

DMax("[Sales]", "[Sales]")

That may look a little strange but the reason for that is you've named the field the same as the table.

Which isn't really a good idea.

 

[mrchonginhk]

Thanks. It works.i tried same formula but I did not use " to quote.
Great... thanks