Crosstabquery

A

an

I have the next crosstabquery:

TRANSFORM Sum(T_General.Val) AS SumOfVal
SELECT T_General.Dt AS Date
FROM T_General
WHERE (((T_General.Param) Like "Temp *"))
GROUP BY T_General.Dt
PIVOT T_General.Param;

I would like create criteria in column "Date: Dt" to
choose the Month.
When I write Between [Choose Month] appear the message:

The Microsoft Jet databese engine does not
recognize '[Choose Month]'...

I would like help to this, please.
Thanks in advance.
an
 
N

Nikos Yannacopoulos

An,

Unlike other query types, crosstabs require that parameters be explicitly
declared as such. To do this, open the query in design view, go Query >
Parameters and place the parameter expression [Choose Month] in the first
available line, selecting the appropriate data type next to it.

HTH,
Nikos
 
A

an

Thanks for your reply.

I need to calc and display data with this query because is
support for a graph, as such:

ParamA ParamB
Date1 Value1 Value2
Date2 Value3 Value4

I don't know as to decide this.
Many thanks.
an
-----Original Message-----
An,

Unlike other query types, crosstabs require that parameters be explicitly
declared as such. To do this, open the query in design view, go Query >
Parameters and place the parameter expression [Choose Month] in the first
available line, selecting the appropriate data type next to it.

HTH,
Nikos

I have the next crosstabquery:

TRANSFORM Sum(T_General.Val) AS SumOfVal
SELECT T_General.Dt AS Date
FROM T_General
WHERE (((T_General.Param) Like "Temp *"))
GROUP BY T_General.Dt
PIVOT T_General.Param;

I would like create criteria in column "Date: Dt" to
choose the Month.
When I write Between [Choose Month] appear the message:

The Microsoft Jet databese engine does not
recognize '[Choose Month]'...

I would like help to this, please.
Thanks in advance.
an
Click to expand...


.
Click to expand...
 
Top