Pivot problem

  • Thread starter Thread starter martin
  • Start date Start date
M

martin

I have a crosstab query with column headings that works
fine. When I take off the column headings I get message ms
jet database does not recognize [forms]!... on a 4th row
with selections. it is exactly the same except no column
heading in properties. if I delete the 4th row it works
also. Here's the sql ..
TRANSFORM Count(sdetail.attended) AS CountOfattended
SELECT age1([dob],Date()) AS age
FROM ...
WHERE (((Schedule.[shift date]) Between [Forms]![zform2]!
[date from] And [Forms]![zform2]![date to]))
GROUP BY age1([dob],Date())
PIVOT [patient rep].sex In ("M","F");
this works
this doesn't
PIVOT [patient rep].sex;

In the end, i'm going to switch row heading with column
heading.

Thanks
Martin
 
Back
Top