By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

criteria in crosstab query

P: n/a
x
hi
i have made a crosstab query in which row heading is "date", colum
heading is "aircraft type" and the value to be summed up is "1-10 row
totals". i want to create a simple query which should just give me the
total value of "1-10 row totals" field by defining a certain criteria.
now when i write the following in the criteria field
Between [enter start date] and [enter end date]
i get an error message saying "The microsoft jet database engine
doesn't recognize [enter start date] as a valid field or expression".
whereas the same criteria works fine when i use it in a normal query.
whats the wrong thing im doing
thanx
bye and tc

Mar 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In query design, choose Parameters on the Query menu.
Enter 2 rows:
[enter start date] Date/Time
[enter end date] Date/Time

It is always a good idea to declare parameters in a query, so Access
understands what data type they are. But in a crosstab, it is essential
(unless you set the Column Headings property.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"x" <cu**************@hotmail.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...
hi
i have made a crosstab query in which row heading is "date", colum
heading is "aircraft type" and the value to be summed up is "1-10 row
totals". i want to create a simple query which should just give me the
total value of "1-10 row totals" field by defining a certain criteria.
now when i write the following in the criteria field
Between [enter start date] and [enter end date]
i get an error message saying "The microsoft jet database engine
doesn't recognize [enter start date] as a valid field or expression".
whereas the same criteria works fine when i use it in a normal query.
whats the wrong thing im doing
thanx
bye and tc

Mar 19 '06 #2

P: n/a
x
thanx it did work and help me
thanx again
bye and tc

Mar 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.