Crosstab query with date paremeters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sql statement indicate below how do I change it so that I can only
chose a period I have a close date and I want to be able to filter the
records from one date to another. what would I need to add to this sql
statement

TRANSFORM Count([QRY_Rep Summary Report 1].ID) AS CountOfID
SELECT [QRY_Rep Summary Report 1].CLT_SPCLST_LName, [QRY_Rep Summary Report
1].CLT_ACTN_ID, Count([QRY_Rep Summary Report 1].ID) AS [Total Of ID]
FROM [QRY_Rep Summary Report 1]
GROUP BY [QRY_Rep Summary Report 1].CLT_SPCLST_LName, [QRY_Rep Summary
Report 1].CLT_ACTN_ID
PIVOT [QRY_Rep Summary Report 1].CLT_RCVRY_TYP_ID;
 
You can filter a crosstab query (or its source query) in the same manner
that you would filter any other query. The major difference is that you MUST
provide the data type of the parameters/criteria. This is done by select
Query->Parameters and entering the exact parameter and the data type ie:

Forms!frmDateSelect!txtStart Date/Time
 
Back
Top