Trying to get a value from a summing query

[Jim McDonald]

Hi all
Any ideas on this one? I want to find the max size of a field in a table, so
say:
SELECT Max(tablename.field) AS MaxNo FROM tablename
and then I want to get the value of MaxNo.
I can do it doing a max-lop etc, but I'd like just to get the field MaxNo,
with the number in it!!
Thanks for any ideas
Jim McDonald

 

[Guest]

Hi Jim,

How about try using DMax()? Lookup Dmax for help.

Hope this will help.

 

[Marshall Barton]

Any ideas on this one? I want to find the max size of a field in a table, so
say:
SELECT Max(tablename.field) AS MaxNo FROM tablename
and then I want to get the value of MaxNo.
I can do it doing a max-lop etc, but I'd like just to get the field MaxNo,
with the number in it!!

Well, you could open a recordset on that query, but why not
just use the DMax function?

DMax("field", "tablename")

 

[Jim McDonald]

Thanks 10^6. Would you believe I just never saw it. Thanks again Jim

 

[Jim McDonald]

Thanks 10^6. Would you believe I just never saw it. Thanks again Jim