Hi,
I have a table that I have created from a query with the following
fields
sort group_name Area month_actual summary
1 M of H Seniors HC 5 funds
2 OHIP Branson 332 other suppl
3 Emp benefits Branson 66 salaries&Wages
4 M of H Seniors HC 33 funds
5 OHIP Seniors HC 98 other suppl
6 Emp benefits Branson 23 salaries&wages
The report that I want to create from this table has group_names as row headings and area as the column headings.The value shown in the report is month actual.
I have created a cross tab query and have sorted my information based on the sort field.
Now the issue that I am having is that the report must also be grouped by the summary field. I do a group by on summary in my cross tab query.
But when it comes to generating the report using a wizard on the cross tab query,the wizard does not show summary in the list box of fields I can group on. All I get in the list box is group_name,dif area names
Can someone please help me out?There must be a way to do this.This is what my query looks like rite now
TRANSFORM Sum(MONTH_ACTUAL) AS [The Value]
SELECT GROUP_NAME, Sum(MONTH_ACTUAL) AS [Total Of MONTH_ACTUAL]
FROM my_tbl
GROUP BY GROUP_NAME, SUMMARY, SORT
ORDER BY SUMMARY DESC , SORT
PIVOT AREA;
Thanks alot..
sync123
I have a table that I have created from a query with the following
fields
sort group_name Area month_actual summary
1 M of H Seniors HC 5 funds
2 OHIP Branson 332 other suppl
3 Emp benefits Branson 66 salaries&Wages
4 M of H Seniors HC 33 funds
5 OHIP Seniors HC 98 other suppl
6 Emp benefits Branson 23 salaries&wages
The report that I want to create from this table has group_names as row headings and area as the column headings.The value shown in the report is month actual.
I have created a cross tab query and have sorted my information based on the sort field.
Now the issue that I am having is that the report must also be grouped by the summary field. I do a group by on summary in my cross tab query.
But when it comes to generating the report using a wizard on the cross tab query,the wizard does not show summary in the list box of fields I can group on. All I get in the list box is group_name,dif area names
Can someone please help me out?There must be a way to do this.This is what my query looks like rite now
TRANSFORM Sum(MONTH_ACTUAL) AS [The Value]
SELECT GROUP_NAME, Sum(MONTH_ACTUAL) AS [Total Of MONTH_ACTUAL]
FROM my_tbl
GROUP BY GROUP_NAME, SUMMARY, SORT
ORDER BY SUMMARY DESC , SORT
PIVOT AREA;
Thanks alot..
sync123