Crosstab Queries

  • Thread starter Thread starter Billy
  • Start date Start date
B

Billy

Thanks for taking the time to read and reply to my
question, I appreciate your help. :)

I have a crosstab querie based on one table. "Products" as
a row heading and Consumers name as the column heading. I
want to create a criteria parameter based on the date the
product was sold, hence I added the date field into the
querie and included the "Between [start date] and [end
date] in the criteria field, but it does not work.
The error reads:
"Microsoft database engine does not recognize [start date]
as a valid field name or expression"

I did this same thing with a simple querie and it works
great, can you help? thanks
 
Crosstab queries demand that you enter the datatype for the parameters. In
design view, go to View, parameters.

In the first cell put
[start date] and choose a datatype of date/time
In the second row put
[end date] and choose a datatype of date/time.
 
Joan thanks for the reply. As you instructed, I entered
the parameter name as [Start date] and [end date] with
their corresponding data type of "date/time" in the
parameter window, but it did not work.

I inserted to sales date field in the querie and put the
condition of "Between [start date] and [end date]" in the
criteria box, but again it did not work.
I got this error:
"The expression is typed incorrectly or is too complex to
evaluate."
can you please help, thanks. again its a crosstab querie.
I have Consumers my row, my products as my columns.

PLEASE NOTE THAT IM DOING A SUM FOR ALL THE PRODUCTS THAT
WERE PURCHASE BY CONSUMER.
-----Original Message-----
Crosstab queries demand that you enter the datatype for the parameters. In
design view, go to View, parameters.

In the first cell put
[start date] and choose a datatype of date/time
In the second row put
[end date] and choose a datatype of date/time.


--
Joan Wild
Microsoft Access MVP

Billy said:
Thanks for taking the time to read and reply to my
question, I appreciate your help. :)

I have a crosstab querie based on one table. "Products" as
a row heading and Consumers name as the column heading. I
want to create a criteria parameter based on the date the
product was sold, hence I added the date field into the
querie and included the "Between [start date] and [end
date] in the criteria field, but it does not work.
The error reads:
"Microsoft database engine does not recognize [start date]
as a valid field name or expression"

I did this same thing with a simple querie and it works
great, can you help? thanks
Click to expand...


.
Click to expand...
 
Post the SQL statement. With the query open, go to View, SQL View, select
all the text, hit Ctrl-C, reply to this post, and hit Ctrl-V.

--
Joan Wild
Microsoft Access MVP

billy said:
Joan thanks for the reply. As you instructed, I entered
the parameter name as [Start date] and [end date] with
their corresponding data type of "date/time" in the
parameter window, but it did not work.

I inserted to sales date field in the querie and put the
condition of "Between [start date] and [end date]" in the
criteria box, but again it did not work.
I got this error:
"The expression is typed incorrectly or is too complex to
evaluate."
can you please help, thanks. again its a crosstab querie.
I have Consumers my row, my products as my columns.

PLEASE NOTE THAT IM DOING A SUM FOR ALL THE PRODUCTS THAT
WERE PURCHASE BY CONSUMER.
-----Original Message-----
Crosstab queries demand that you enter the datatype for the parameters. In
design view, go to View, parameters.

In the first cell put
[start date] and choose a datatype of date/time
In the second row put
[end date] and choose a datatype of date/time.


--
Joan Wild
Microsoft Access MVP

Billy said:
Thanks for taking the time to read and reply to my
question, I appreciate your help. :)

I have a crosstab querie based on one table. "Products" as
a row heading and Consumers name as the column heading. I
want to create a criteria parameter based on the date the
product was sold, hence I added the date field into the
querie and included the "Between [start date] and [end
date] in the criteria field, but it does not work.
The error reads:
"Microsoft database engine does not recognize [start date]
as a valid field name or expression"

I did this same thing with a simple querie and it works
great, can you help? thanks
Click to expand...


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