Cross Tab Query

[Guest]

Hello,

I wanted to know how to use a cross tab query that will pull the data based
on a series of dates. I tried to add Between [Enter Start Date] And [Enter
Ending Date] to the date field, but I get The Microsoft Jet database
engine does not recongnize '[Enter Start Date]' as a valid field name or
expression. Any help would be greatly appericated.

Rocket

 

[John Spencer]

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

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

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

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Hello,

I wanted to know how to use a cross tab query that will pull the data
based
on a series of dates. I tried to add Between [Enter Start Date] And
[Enter
Ending Date] to the date field, but I get The Microsoft Jet database
engine does not recongnize '[Enter Start Date]' as a valid field name or
expression. Any help would be greatly appericated.

Rocket

John,

Thanks for the quick responce! I did try that and I still got the same
error. I had the cross tab query based from another query. I removed the
Between [Enter Start Date] And [Enter Ending Date] from the query and then
did what you sugested, and the cross tab query work, but it did not give the
range of dates. I am puzzled. Any other help would be GREAT!

Thanks again,
Rocket

 

[Guest]

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

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Hello,

I wanted to know how to use a cross tab query that will pull the data
based
on a series of dates. I tried to add Between [Enter Start Date] And
[Enter
Ending Date] to the date field, but I get The Microsoft Jet database
engine does not recongnize '[Enter Start Date]' as a valid field name or
expression. Any help would be greatly appericated.

Rocket

John,

Thanks for the quick responce! I did try that and I still got the same
error. I had the cross tab query based from another query. I removed the
Between [Enter Start Date] And [Enter Ending Date] from the query and then
did what you sugested, and the cross tab query work, but it did not give the
range of dates. I am puzzled. Any other help would be GREAT!

Thanks again,
Rocket

I figured out what I was doing wrong. I was putting the brackets around the
parameter.

Thank you again for your time and help.

Rocket