Hi all,
I have an accident database that I am trying to write a pivot query for.
the following works:
TRANSFORM Nz(Count([I_BA]),0) AS [The Value]
SELECT TblMonthlyInjurySummary.I_BA
FROM TblMonthlyInjurySummary
WHERE ((TblMonthlyInjurySummary.I_Date) Between #7/1/2000# And #6/30/2011#)
GROUP...