Query/Report Structure Question

[tg7]

I would like to build a report that shows the names of medical facilities in
the left row, column headings will be the audit names, and the results will
be the data. I built a crosstab query, and then the report, and everything
worked fine, until changes were made to when the audits schedule, now I need
to group the audit names by the quarter they are due. Some audits will be
due multiple quarters based on the facility results. I am stuck in how to
accomplish this.

Here is my SQL for the crosstab query. I am not a very advanced user and
could use some help. I posted in an earlier post, but probably didn't
explain my dilemma very well.
TRANSFORM Min([AuditResultsQuery].[AuditResults]) AS [MinOfAuditResults]
SELECT [AuditResultsQuery].[MedicalCenter]
FROM [AuditResultsQuery]
GROUP BY [AuditResultsQuery].[MedicalCenter]
PIVOT [Audit ResultsQuery].[AuditName];

Also, some audits will be moving to 2008, and my superiors want to move them
to a second page, should the crosstab be added as a subreport so that I could
insert a page break in the main report?

 

[KARL DEWEY]

Search on -- Report on Crosstab query
In --- microsoft.public.access.reports
Response by --- Duane Hookom

 

[tg7]

When I click on the link, the page that opens does not have any downloads or
other files to view.

Search on -- Report on Crosstab query
In --- microsoft.public.access.reports
Response by --- Duane Hookom
--
KARL DEWEY
Build a little - Test a little

I would like to build a report that shows the names of medical facilities in
the left row, column headings will be the audit names, and the results will
be the data. I built a crosstab query, and then the report, and everything
worked fine, until changes were made to when the audits schedule, now I need
to group the audit names by the quarter they are due. Some audits will be
due multiple quarters based on the facility results. I am stuck in how to
accomplish this.

Here is my SQL for the crosstab query. I am not a very advanced user and
could use some help. I posted in an earlier post, but probably didn't
explain my dilemma very well.
TRANSFORM Min([AuditResultsQuery].[AuditResults]) AS [MinOfAuditResults]
SELECT [AuditResultsQuery].[MedicalCenter]
FROM [AuditResultsQuery]
GROUP BY [AuditResultsQuery].[MedicalCenter]
PIVOT [Audit ResultsQuery].[AuditName];

Also, some audits will be moving to 2008, and my superiors want to move them
to a second page, should the crosstab be added as a subreport so that I could
insert a page break in the main report?

 

[KARL DEWEY]

Seach Access for Dynamic Report
--
KARL DEWEY
Build a little - Test a little

When I click on the link, the page that opens does not have any downloads or
other files to view.

Search on -- Report on Crosstab query
In --- microsoft.public.access.reports
Response by --- Duane Hookom
--
KARL DEWEY
Build a little - Test a little

I would like to build a report that shows the names of medical facilities in
the left row, column headings will be the audit names, and the results will
be the data. I built a crosstab query, and then the report, and everything
worked fine, until changes were made to when the audits schedule, now I need
to group the audit names by the quarter they are due. Some audits will be
due multiple quarters based on the facility results. I am stuck in how to
accomplish this.

Here is my SQL for the crosstab query. I am not a very advanced user and
could use some help. I posted in an earlier post, but probably didn't
explain my dilemma very well.
TRANSFORM Min([AuditResultsQuery].[AuditResults]) AS [MinOfAuditResults]
SELECT [AuditResultsQuery].[MedicalCenter]
FROM [AuditResultsQuery]
GROUP BY [AuditResultsQuery].[MedicalCenter]
PIVOT [Audit ResultsQuery].[AuditName];

Also, some audits will be moving to 2008, and my superiors want to move them
to a second page, should the crosstab be added as a subreport so that I could
insert a page break in the main report?