Crosstab Query

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

Is there a way to have a crosstab query prompt the user for criteria?
I tried everything and continue to get the jet engine does not recongnize
[enter start date] as a vaild field name or expression. Can someone please
help

Floyd
 
Make use you enter the query parameter data types. Select Query->Parameters
and enter:
[enter start date] Date/Time
 
When I do the parameter query it queries everything and not just the date.
What am I doing wrong?


Floyd

Duane Hookom said:
Make use you enter the query parameter data types. Select
Query->Parameters and enter:
[enter start date] Date/Time

--
Duane Hookom
MS Access MVP
--

Floyd Forbes said:
Is there a way to have a crosstab query prompt the user for criteria?
I tried everything and continue to get the jet engine does not recongnize
[enter start date] as a vaild field name or expression. Can someone
please help

Floyd
Click to expand...
Click to expand...
 
Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message


Floyd Forbes said:
When I do the parameter query it queries everything and not just the date.
What am I doing wrong?


Floyd

Duane Hookom said:
Make use you enter the query parameter data types. Select
Query->Parameters and enter:
[enter start date] Date/Time

--
Duane Hookom
MS Access MVP
--

Floyd Forbes said:
Is there a way to have a crosstab query prompt the user for criteria?
I tried everything and continue to get the jet engine does not
recongnize
[enter start date] as a vaild field name or expression. Can someone
please help

Floyd
Click to expand...
Click to expand...
Click to expand...
 
Please teel what is wrong with this.

TRANSFORM Sum(quyWhs2.SumOfKeyStrokes) AS SumOfSumOfKeyStrokes
SELECT quyWhs2.OperID, quyWhs2.date1
FROM quyWhs2
WHERE (((quyWhs2.date1)=[please enter date]))
GROUP BY quyWhs2.OperID, quyWhs2.date1
PIVOT quyWhs2.Codes;

John Spencer said:
Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message


Floyd Forbes said:
When I do the parameter query it queries everything and not just the
date.
What am I doing wrong?


Floyd

Duane Hookom said:
Make use you enter the query parameter data types. Select
Query->Parameters and enter:
[enter start date] Date/Time

--
Duane Hookom
MS Access MVP
--

Is there a way to have a crosstab query prompt the user for criteria?
I tried everything and continue to get the jet engine does not
recongnize
[enter start date] as a vaild field name or expression. Can someone
please help

Floyd
Click to expand...
Click to expand...
Click to expand...
 
As my first reply suggested, select Query->Parameters and enter
[please enter date] Date/Time
Don't take the parameter out of the criteria.

--
Duane Hookom
MS Access MVP
--

Floyd Forbes said:
Please teel what is wrong with this.

TRANSFORM Sum(quyWhs2.SumOfKeyStrokes) AS SumOfSumOfKeyStrokes
SELECT quyWhs2.OperID, quyWhs2.date1
FROM quyWhs2
WHERE (((quyWhs2.date1)=[please enter date]))
GROUP BY quyWhs2.OperID, quyWhs2.date1
PIVOT quyWhs2.Codes;

John Spencer said:
Please copy and post the SQL of your query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message


Floyd Forbes said:
When I do the parameter query it queries everything and not just the
date.
What am I doing wrong?


Floyd

Make use you enter the query parameter data types. Select
Query->Parameters and enter:
[enter start date] Date/Time

--
Duane Hookom
MS Access MVP
--

Is there a way to have a crosstab query prompt the user for criteria?
I tried everything and continue to get the jet engine does not
recongnize
[enter start date] as a vaild field name or expression. Can someone
please help

Floyd
Click to expand...
Click to expand...
Click to expand...
 
Back
Top