Cross Tab Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
..
 
John Spencer said:
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
..

Rocket said:
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
Click to expand...


John,
Click to expand...

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
 
Rocket said:
John Spencer said:
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
..

Rocket said:
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
Click to expand...


John,
Click to expand...

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
Click to expand...

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
 
Back
Top