Getting a max number in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi

I am trying toget a query to display the max numbe only. I have a field
linked to other fields, this field stored a number for a report version.
Usually this is 1, but sometimes it can be 2 or 3 etc. How can I get the
query to only display the data for the max number in that field, be it 1,2 3
etc. Is this indeed possible. At the min I get duplicate records for results
that have more than one report version, ie the query displays all report
versions rather than the most recent, or max number.

Many Thanks
 
SELECT *
FROM SomeTable
WHERE Version = (SELECT Max(Version) FROM SomeTable st WHERE st.OtherField =
SomeTable.OtherField)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max Query 1
MIN/MAX not working 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Group By, Max and Min 2
The not "Max" records 1
Max Date in a query whilst showing all fields 4
Max Query 2
How to add another field to a max query result without grouping 1

Back
Top