Trying to get a value from a summing query

  • Thread starter Thread starter Jim McDonald
  • Start date Start date
J

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
 
Jim said:
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!!
Click to expand...


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

DMax("field", "tablename")
 
Back
Top