SQL - SELECT MAX versus SELECT LIMIT

[Amyfb]

I want to return a list of documents with only the most current version number.



Seems I should be able to do this one of two ways, but I can't make either work.

SELECT MAX (fieldname) FROM (qryname) works with a single column query, but not with multi columns.

SELECT (fieldnames) FROM (qryName) ORDER BY (desc) LIMIT (1) I can't get it to work at all. It works fine till I try to insert the limit condition then it throws a syntax error. I've entered the limit value with and without parentheses or brackets, and I've placed it at different points within the statement, to no avail.

I'll take any ideas from the group mind here!

thanks
Amy

[June7]

I don't think Access supports LIMIT.

If you want to find multiple records with most recent (maximum) number, review https://support.microsoft.com/en-us/...4-686c216c91d8

Also http://allenbrowne.com/subquery-01.html#TopN

[moke123]

Can you use Select Top?

[Amyfb]

Thanks for the inputs. I accomplished the goal with a descending sort on a different column.