limiting the number of grouped records in a query 1

[thebluffer]

Is there a way to run a query to limit the number of Grouped records in a query to 12. I work in real estate and have 100+ different properties. each month I enter financial statements for each property and some properties may have 40 or more records. I need to run calculations on a each property with just the last 12 months of financial data. Date manipulation won't work as I do not also have the just recent months financial statements for each property. Thanks for any help. Jim

 

[Aivars]

Example:

SELECT Top 12 FileList.FileCreatedTime, Count(FileList.FileType) AS CountOfFileType
FROM FileList
GROUP BY FileList.FileCreatedTime;

Note! Top 12 is possibly to set only in SQL.

Aivars

Look at thread705-102904 for function what creates SQL with top value by VBA coding.