Report from crosstab query problem

[Joe]

I am unable to view any available fields from my crosstab query when I
attempt to create a report either manually or with the wizard - the field
list remains blank.
The SQL for the crosstab query is:

PARAMETERS [Enter Start Date:] DateTime, [Enter End Date:] DateTime;
TRANSFORM Count([Body part diagnosis by therapist query].mb_service_number)
AS CountOfmb_service_number
SELECT [Body part diagnosis by therapist query].body_part, [Body part
diagnosis by therapist query].diagnosis, Count([Body part diagnosis by
therapist query].mb_service_number) AS [Total Of mb_service_number]
FROM [Body part diagnosis by therapist query]
WHERE ((([Patient Treatments Table].first_attendance) Between [Enter Start
Date:] And [Enter End Date:]))
GROUP BY [Body part diagnosis by therapist query].body_part, [Body part
diagnosis by therapist query].diagnosis
PIVOT [Body part diagnosis by therapist query].therapist;

I am grateful for any advice that will point me in the right direction.

Regards,

Joe

 

[Allen Browne]

In query design view, open the Properties box, and enter the valid column
heading values beside the Column Headings property.

More info:
Crosstab query techniques:
at:
http://allenbrowne.com/ser-67.html#ColHead

Post back if you are still stuck.

 

[Joe]

Many thanks,

That solved the problem...

Joe

In query design view, open the Properties box, and enter the valid column
heading values beside the Column Headings property.

More info:
Crosstab query techniques:
at:
http://allenbrowne.com/ser-67.html#ColHead

Post back if you are still stuck.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am unable to view any available fields from my crosstab query when I
attempt to create a report either manually or with the wizard - the field
list remains blank.
The SQL for the crosstab query is:

PARAMETERS [Enter Start Date:] DateTime, [Enter End Date:] DateTime;
TRANSFORM Count([Body part diagnosis by therapist
query].mb_service_number)
AS CountOfmb_service_number
SELECT [Body part diagnosis by therapist query].body_part, [Body part
diagnosis by therapist query].diagnosis, Count([Body part diagnosis by
therapist query].mb_service_number) AS [Total Of mb_service_number]
FROM [Body part diagnosis by therapist query]
WHERE ((([Patient Treatments Table].first_attendance) Between [Enter Start
Date:] And [Enter End Date:]))
GROUP BY [Body part diagnosis by therapist query].body_part, [Body part
diagnosis by therapist query].diagnosis
PIVOT [Body part diagnosis by therapist query].therapist;

I am grateful for any advice that will point me in the right direction.

Regards,

Joe