Crosstab Queries

[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

 

[Joan Wild]

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.

 

[billy]

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

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

.

 

[Joan Wild]

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

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

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

.