max function (1 Viewer)

[willem]

I am trying to create a query that selects all last dates before a certain date . One person can have many dates. When i use the max function it just gives me the dates that are under the certain date.

I expect more from a max function

 

[AlanS]

The Max function returns only the single greatest value from a particular group. If you want all the values before a certain date, try using a criteria in your query, e.g. <#7/1/01#. You can then switch to SQL view to see how it is expressed in SQL.