G
Gregw
I have two Queries that I am trying to combine:
SELECT Year([OrderDate]) AS [Year], Month([OrderDate]) AS [Month],
Count(File_Tracking.FileNumber) AS CountofFileNumber
FROM File_Tracking
GROUP BY Year([OrderDate]), Month([OrderDate]);
which gives me the number of files ordered for each month. But I also have
another query:
SELECT Year([ClosingDate]) AS [Year], Month([ClosingDate]) AS [Month],
Count(File_Tracking.FileNumber) AS Files, Sum([Gross]) AS SumofGross
FROM File_Tracking
WHERE ([ClosingDate]) Is Not Null
GROUP BY Year([ClosingDate]), Month([ClosingDate]);
which will give me how many files closed in each month, as well as the sum
of gross dollars for each file. I have been trying to combine these two
queries into one query so that I could come up with percentages for each
month automatically, but I keep stumbling, any help would be greatly
appreciated.
SELECT Year([OrderDate]) AS [Year], Month([OrderDate]) AS [Month],
Count(File_Tracking.FileNumber) AS CountofFileNumber
FROM File_Tracking
GROUP BY Year([OrderDate]), Month([OrderDate]);
which gives me the number of files ordered for each month. But I also have
another query:
SELECT Year([ClosingDate]) AS [Year], Month([ClosingDate]) AS [Month],
Count(File_Tracking.FileNumber) AS Files, Sum([Gross]) AS SumofGross
FROM File_Tracking
WHERE ([ClosingDate]) Is Not Null
GROUP BY Year([ClosingDate]), Month([ClosingDate]);
which will give me how many files closed in each month, as well as the sum
of gross dollars for each file. I have been trying to combine these two
queries into one query so that I could come up with percentages for each
month automatically, but I keep stumbling, any help would be greatly
appreciated.