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

Reports, filters and crosstabs

P: n/a
I am using VBA to determine which query sits behind a report,
depending upon the preferred sort order. This has worked perfectly
for ordinary select queries behind reports, but it seems to be
struggling with crosstab reports. It presents a "jet engine" error.
Do you know if this is an issue, or is there a better way of doing
this?

Thanks in anticipation.

Cassie
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
The sort order of the query is often irrelevant to the presentation on the
report.
It's better to set the sort order as a property of the report itself.
I'd suggest the report's OnOpen event as the place to do this.

HTH
- Turtle

"Cassie Pennington" <ca************@btinternet.com> wrote in message
news:47**************************@posting.google.c om...
I am using VBA to determine which query sits behind a report,
depending upon the preferred sort order. This has worked perfectly
for ordinary select queries behind reports, but it seems to be
struggling with crosstab reports. It presents a "jet engine" error.
Do you know if this is an issue, or is there a better way of doing
this?

Thanks in anticipation.

Cassie

Nov 13 '05 #2

P: n/a
Oh, and if you're filtering a crosstab query using parameters (e.g.
referencing controls on a form), be sure to declare those parameters
explicitly using the parameters dialog (Query - Parameters).
"Cassie Pennington" <ca************@btinternet.com> wrote in message
news:47**************************@posting.google.c om...
I am using VBA to determine which query sits behind a report,
depending upon the preferred sort order. This has worked perfectly
for ordinary select queries behind reports, but it seems to be
struggling with crosstab reports. It presents a "jet engine" error.
Do you know if this is an issue, or is there a better way of doing
this?

Thanks in anticipation.

Cassie

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.