I have following crosstab query
TRANSFORM Count(PRESENT.Pr_Ab) AS CountOfPr_Ab1
SELECT STUDENT.Student_id, STUDENT.Name, Month([PRESENT.DATE]) AS Expr1, Year([PRESENT.DATE]) AS Expr2, Count(PRESENT.Pr_Ab) AS TOTAL
FROM PRESENT INNER JOIN STUDENT ON PRESENT.Student_ID = STUDENT.Student_id
GROUP BY STUDENT.Student_id, STUDENT.Name, Month([PRESENT.DATE]), Year([PRESENT.DATE])
PIVOT PRESENT.Pr_Ab;
Now i want to enter parameter in expr1 (number of the month)

concantenate your expression, so that it calculates, to your SQL string.

How i concantenate my expression?

Month([PRESENT.DATE]) AS Expr1,

should be

[Specify the Month] AS Expr1,

The latter will issue a prompt to "Specify the Month" when the query is executed. I mis-spoke when I said "concantenate."