G
Gregw
I am using the following query:
SELECT Year([ClosingDate]) AS [Year], Month([ClosingDate]) AS [Month],
Count(File_Tracking.FileNumber) AS Files
FROM File_Tracking
WHERE ([ClosingDate]) Is Not Null
GROUP BY Year([ClosingDate]), Month([ClosingDate]);
Which will give us the number of files that closed for each specific month.
We have an additional field in our table called "Gross". Is there an easy
way to sum up the gross amount for each file (that closed), thereby getting a
Gross amount for all files closed for each month? (I was trying to use the
Sum function but couldn't get it to work correclty with my query). Any help
would be greatly appreciated.
Thanks
SELECT Year([ClosingDate]) AS [Year], Month([ClosingDate]) AS [Month],
Count(File_Tracking.FileNumber) AS Files
FROM File_Tracking
WHERE ([ClosingDate]) Is Not Null
GROUP BY Year([ClosingDate]), Month([ClosingDate]);
Which will give us the number of files that closed for each specific month.
We have an additional field in our table called "Gross". Is there an easy
way to sum up the gross amount for each file (that closed), thereby getting a
Gross amount for all files closed for each month? (I was trying to use the
Sum function but couldn't get it to work correclty with my query). Any help
would be greatly appreciated.
Thanks