Isn't possible?

[an]

Hello!

Isn't possible to aply Between[date1] And [Date2] on
criteria row in crosstab query, please?

Tahnks in advance.
an

 

[Guest]

hi,
yes. >= date1 and < date2
< date2 will exclude the accual date. <= will include it

 

[an]

Ok.
But I would like to choose [Date1] and [Date2]The problem
is the error message:
The Microsoft Jet databese engine does not
recognize '[Date1]'...
(?)
Thanks.
an

-----Original Message-----
hi,
yes. >= date1 and < date2
< date2 will exclude the accual date. <= will include it

-----Original Message-----
Hello!

Isn't possible to aply Between[date1] And [Date2] on
criteria row in crosstab query, please?

Tahnks in advance.
an


.

.

 

[John Spencer (MVP)]

Yes, it is possible, but with crosstab queries, you MUST declare your
parameters. With other queries, declaring your parameters is OPTIONAL, although
it is a good idea to do so.

First thing, with a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2

Repeat for each parameter.

Ok.
But I would like to choose [Date1] and [Date2]The problem
is the error message:
The Microsoft Jet databese engine does not
recognize '[Date1]'...
(?)
Thanks.
an

-----Original Message-----
hi,
yes. >= date1 and < date2
< date2 will exclude the accual date. <= will include it

-----Original Message-----
Hello!

Isn't possible to aply Between[date1] And [Date2] on
criteria row in crosstab query, please?

Tahnks in advance.
an


.

.