Crosstabquery

  • Thread starter Thread starter an
  • Start date Start date
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
 
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
 
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...
 
Back
Top