D
doreendev
I have created a database that logs productivity numbers for employees, and
need to create a report that will give me information based on a quarterly
basis. I have created a query that asks the criteria question "what quarter"
and want the report to show the quarter "q1", "q2", etc. and have information
gathered to consolidate all the data during that particular quarter for this
report, but don't want to have to build a separate query for each month
manually. Is there a way for Access to do this? And please in english if
you don't mind, I'm not good at the jargon used, new to access.
So what I want -
Bill's Q4 2006 Report
# of Hours Worked: 300 - Oct: 100, Nov: 80, Dec: 120
# of Items Worked: 400 - Oct: 200, Nov: 100, Dec: 200
I can get the # of Hours worked for the quarter, and the # of items, but not
the details for each month.
need to create a report that will give me information based on a quarterly
basis. I have created a query that asks the criteria question "what quarter"
and want the report to show the quarter "q1", "q2", etc. and have information
gathered to consolidate all the data during that particular quarter for this
report, but don't want to have to build a separate query for each month
manually. Is there a way for Access to do this? And please in english if
you don't mind, I'm not good at the jargon used, new to access.
So what I want -
Bill's Q4 2006 Report
# of Hours Worked: 300 - Oct: 100, Nov: 80, Dec: 120
# of Items Worked: 400 - Oct: 200, Nov: 100, Dec: 200
I can get the # of Hours worked for the quarter, and the # of items, but not
the details for each month.