Crosstab Query Problem

[tg7]

I have searched through the posts and not found an answer, and frankly am not
even sure how to search for what I am trying to do. I do not have any
programming expertise, just a basic user of Access. I hope that someone can
help me, I am feeling way over my head.

I have a database whose purpose is to track audit results. I have a report
based on a crosstab query that lists row-MedicalCenter, column-AuditName, and
the value is AuditResult (min). I have labels in the header of the report
that show what quarter the audit is conducted, but this is for visual only, I
placed the AuditName fields from the crosstab query in the order I wanted by
manually formatting the report.

The problem is if the audit result is below 94% additional quarterly audits
are required. My supervisors want that particular AuditName to show in Q2,
Q3 until 95% is achieved. I can't figure out how to show the AuditName
multiple times in the report in the format my superiors want. I could do it
easily in Excel, but that defeats the purpose of having the data in Access.
I want to do something like this:

Q1 Q2
Q3 Q4
Medical Center PT CRNA NP PT MD ROI PT MD Ortho
MD Ortho
CVA 92% 95% 96% 94%89% 95% 96%93%92% 98% 96%
NVA 95% 95% 96% 94% 96% 98% 95%
TVA 94% 96% 98% 96% 82% 96% 97% 92%
97%

Should I not be using a crosstab query? Any suggestions would be appreciated.

 

[KARL DEWEY]

Post the SQL for the crosstab and also feeder query if the quarter selection
is done in a query ahead of the crosstab.

 

[tg7]

Thanks for the help, here is the crosstab SQL. I do not know have a feeder
query. To clarify, currently the audit names are grouped into quarters
manually in the design layout of the report. I need to know the best way to
show an audit result in quarter 2 based on the results of quarter 1....can
this be done?

TRANSFORM Min([AuditResultsQuery].[Audit Results]) AS [MinOfAuditResults]
SELECT [AuditResultsQuery].[MedicalCenter]
FROM [AuditResultsQuery]
GROUP BY [AuditResultsQuery].[MedicalCenter]
PIVOT [AuditResultsQuery].[AuditName];