R
Roger Tregelles
Hi Folks,
I need to create a query that I can use to create a chart from within
Access. I create monthly reports that show a 12 month snapshot of our
records (bar charts by month). The main information I would be getting from
a table would be Date Issued and Disposition type. I typically run a query
that uses the Criteria "Between xx/xx And xx/xx" with a specific disposition
"Like Rejected" to get 12 months of data and then manually input this into
Excel. I need a way to get 12 sets if numbers (counts) and then chart on
these from within Access. What would be the best way to do this? Would I
need to create 12 queries (one for each month) and then reference all 12 in
one query to chart on the actual counts? Sorry if this sounds really simple,
but I'm banging my head against the wall as I've never created anything like
this in Access before. Any help, direction or advice on creating queries
like these would be greatly appreciated. Thanks in advance.
Roger Tregelles
I need to create a query that I can use to create a chart from within
Access. I create monthly reports that show a 12 month snapshot of our
records (bar charts by month). The main information I would be getting from
a table would be Date Issued and Disposition type. I typically run a query
that uses the Criteria "Between xx/xx And xx/xx" with a specific disposition
"Like Rejected" to get 12 months of data and then manually input this into
Excel. I need a way to get 12 sets if numbers (counts) and then chart on
these from within Access. What would be the best way to do this? Would I
need to create 12 queries (one for each month) and then reference all 12 in
one query to chart on the actual counts? Sorry if this sounds really simple,
but I'm banging my head against the wall as I've never created anything like
this in Access before. Any help, direction or advice on creating queries
like these would be greatly appreciated. Thanks in advance.
Roger Tregelles