knuckelhead
Technical User
the following sql is my crosstab query.
TRANSFORM Count(QryJobDetail.CusLocID) AS CountOfCusLocID
SELECT QryJobDetail.LocFullName, QryJobDetail.LotBlock, QryJobDetail.LocFullAddress
FROM QryJobDetail
WHERE (((QryJobDetail.JobStatus)="appt"))
GROUP BY QryJobDetail.LocFullName, QryJobDetail.LotBlock, QryJobDetail.LocFullAddress
PIVOT Format([JobDate],"Short Date");
i want to have on the criteria line or somewhere, like the following.
Between [Begin Date] and [Ending Date]
i get an error message.
thanks
TRANSFORM Count(QryJobDetail.CusLocID) AS CountOfCusLocID
SELECT QryJobDetail.LocFullName, QryJobDetail.LotBlock, QryJobDetail.LocFullAddress
FROM QryJobDetail
WHERE (((QryJobDetail.JobStatus)="appt"))
GROUP BY QryJobDetail.LocFullName, QryJobDetail.LotBlock, QryJobDetail.LocFullAddress
PIVOT Format([JobDate],"Short Date");
i want to have on the criteria line or somewhere, like the following.
Between [Begin Date] and [Ending Date]
i get an error message.
thanks