date parameter and crosstab query problem

[LMB]

Hi Guys,

I am using Access 2000.

I created a crosstab query. The sql is below in case that helps you.

TRANSFORM Max(qryrptTherapistAuditNumbers.CountOfEmpAuditID) AS
MaxOfCountOfEmpAuditID
SELECT qryrptTherapistAuditNumbers.Employee
FROM qryrptTherapistAuditNumbers
GROUP BY qryrptTherapistAuditNumbers.Employee
PIVOT qryrptTherapistAuditNumbers.AuditName;

When I add my date parameter...

Between [Start Date] And [End Date]

....to the underlying query that my crosstab is based on,
qryrptTherapistAuditNumbers, I get the error message below.

The Microsoft jet database engine does not recognize '[startdate]' as a
valid field name or expression.

The crosstab query is perfect but I need to run this query every week and
only have the records from a specific time period, not all the records in
the database. Actually, I only need records that begin at a certain date
and go until today (today being the date I am running the query)

Thanks,
Linda

 

[Duane Hookom]

This question gets asked and answered several times each week in this or the
reports news group. You must specify the data type of all parameters in a
crosstab query. Select Query->Parameters and enter:
[Start Date] Date/Time
[End Date] Date/Time

 

[LMB]

Thanks and sorry about that. Glad you mentioned it though because I have
been meaning to get better at using the search feature to find other
questions similar to what I am asking. I did a search for a "crosstab" in
the subject field of the newsgroup and came up with some other questions
that were the same. Are there any tips anyone can give to search for
questions that may already have the answers to our questions other than what
I did?

It took me a while to find the parameters but once I did, I got it to work.
There sure are about a hundred little things hidden in access for any task!

Thanks so much,
Linda

This question gets asked and answered several times each week in this or
the reports news group. You must specify the data type of all parameters
in a crosstab query. Select Query->Parameters and enter:
[Start Date] Date/Time
[End Date] Date/Time

--
Duane Hookom
MS Access MVP

Hi Guys,

I am using Access 2000.

I created a crosstab query. The sql is below in case that helps you.

TRANSFORM Max(qryrptTherapistAuditNumbers.CountOfEmpAuditID) AS
MaxOfCountOfEmpAuditID
SELECT qryrptTherapistAuditNumbers.Employee
FROM qryrptTherapistAuditNumbers
GROUP BY qryrptTherapistAuditNumbers.Employee
PIVOT qryrptTherapistAuditNumbers.AuditName;

When I add my date parameter...

Between [Start Date] And [End Date]

...to the underlying query that my crosstab is based on,
qryrptTherapistAuditNumbers, I get the error message below.

The Microsoft jet database engine does not recognize '[startdate]' as a
valid field name or expression.

The crosstab query is perfect but I need to run this query every week and
only have the records from a specific time period, not all the records in
the database. Actually, I only need records that begin at a certain date
and go until today (today being the date I am running the query)

Thanks,
Linda

 

[Duane Hookom]

I use Google Groups advance search. You can enter a group matching
"*access.Queries*" and search for "Does not recognize"

--
Duane Hookom
MS Access MVP

Thanks and sorry about that. Glad you mentioned it though because I have
been meaning to get better at using the search feature to find other
questions similar to what I am asking. I did a search for a "crosstab" in
the subject field of the newsgroup and came up with some other questions
that were the same. Are there any tips anyone can give to search for
questions that may already have the answers to our questions other than
what I did?

It took me a while to find the parameters but once I did, I got it to
work. There sure are about a hundred little things hidden in access for
any task!

Thanks so much,
Linda

This question gets asked and answered several times each week in this or
the reports news group. You must specify the data type of all parameters
in a crosstab query. Select Query->Parameters and enter:
[Start Date] Date/Time
[End Date] Date/Time

--
Duane Hookom
MS Access MVP

Hi Guys,

I am using Access 2000.

I created a crosstab query. The sql is below in case that helps you.

TRANSFORM Max(qryrptTherapistAuditNumbers.CountOfEmpAuditID) AS
MaxOfCountOfEmpAuditID
SELECT qryrptTherapistAuditNumbers.Employee
FROM qryrptTherapistAuditNumbers
GROUP BY qryrptTherapistAuditNumbers.Employee
PIVOT qryrptTherapistAuditNumbers.AuditName;

When I add my date parameter...

Between [Start Date] And [End Date]

...to the underlying query that my crosstab is based on,
qryrptTherapistAuditNumbers, I get the error message below.

The Microsoft jet database engine does not recognize '[startdate]' as a
valid field name or expression.

The crosstab query is perfect but I need to run this query every week
and only have the records from a specific time period, not all the
records in the database. Actually, I only need records that begin at a
certain date and go until today (today being the date I am running the
query)

Thanks,
Linda

 

[LMB]

Wow! That will be great. I can't access this group at work and always have
to e-mail myself a note to remind myself to ask my question when I get home.
I think I would be able to view these from there. I'll be trying tomorrow.

Thanks a million.

Linda

I use Google Groups advance search. You can enter a group matching
"*access.Queries*" and search for "Does not recognize"

--
Duane Hookom
MS Access MVP

Thanks and sorry about that. Glad you mentioned it though because I have
been meaning to get better at using the search feature to find other
questions similar to what I am asking. I did a search for a "crosstab"
in the subject field of the newsgroup and came up with some other
questions that were the same. Are there any tips anyone can give to
search for questions that may already have the answers to our questions
other than what I did?

It took me a while to find the parameters but once I did, I got it to
work. There sure are about a hundred little things hidden in access for
any task!

Thanks so much,
Linda

This question gets asked and answered several times each week in this or
the reports news group. You must specify the data type of all parameters
in a crosstab query. Select Query->Parameters and enter:
[Start Date] Date/Time
[End Date] Date/Time

--
Duane Hookom
MS Access MVP


Hi Guys,

I am using Access 2000.

I created a crosstab query. The sql is below in case that helps you.

TRANSFORM Max(qryrptTherapistAuditNumbers.CountOfEmpAuditID) AS
MaxOfCountOfEmpAuditID
SELECT qryrptTherapistAuditNumbers.Employee
FROM qryrptTherapistAuditNumbers
GROUP BY qryrptTherapistAuditNumbers.Employee
PIVOT qryrptTherapistAuditNumbers.AuditName;

When I add my date parameter...

Between [Start Date] And [End Date]

...to the underlying query that my crosstab is based on,
qryrptTherapistAuditNumbers, I get the error message below.

The Microsoft jet database engine does not recognize '[startdate]' as a
valid field name or expression.

The crosstab query is perfect but I need to run this query every week
and only have the records from a specific time period, not all the
records in the database. Actually, I only need records that begin at a
certain date and go until today (today being the date I am running the
query)

Thanks,
Linda