Help with Maximum Summary Function 1

[JohnSushames]

My database contains a field which records the dates of reviews completed, of which there are a number of different types. I need to be able to find tha maximum (latest date) from the field for each type of review. My query is how can I limit the maximum function to look at only one type of review at a time? The type of review is indicated by a separate field within the same table.

If anyone has any idea how to do this it would be much appreciated!!!!

 

[balves]

You need to create a GROUP for the review type. Then do a max function on the review date in the group.