Google Answers Logo
View Question
Q: Access Reporting - Hammer ( Answered 5 out of 5 stars,   0 Comments )
Subject: Access Reporting - Hammer
Category: Computers > Programming
Asked by: bselltiz-ga
List Price: $5.00
Posted: 05 May 2003 09:56 PDT
Expires: 04 Jun 2003 09:56 PDT
Question ID: 199657
I need to sort a report based upon user input from a form. The form
has a custom list of names corresponding to field names in the
report's recordsource. The user chooses a name then either ascending
or descending and then clicks print. The problem is that I can not put
the report into design view since this will be for an application
being run as an mde.
Subject: Re: Access Reporting - Hammer
Answered By: hammer-ga on 05 May 2003 10:56 PDT
Rated:5 out of 5 stars

In cases where just changing the WHERE clause won't do it for you, you
can build the recordset on which you want the report based in runtime,
giving you complete control over it. Detailed instructions and sample
code can be found in an MVPS Access FAQ topic.

Use a recordset as report's datasource

- Hammer

Request for Answer Clarification by bselltiz-ga on 05 May 2003 20:52 PDT
I like this technique - pretty cool. Only problem is that the report
will still not sort correctly. Any other changes to the recordsource I
make show up correctly and even if I copy the string into a query the
query will sort the way I want. It just won't do it in the report. Any
idea why this might be happening?

Clarification of Answer by hammer-ga on 06 May 2003 04:37 PDT

Are you forcing a different sort order in the report design using the
Sorting and Grouping dialog? If clearing that doesn't help, could you
upload an mdb with enough elements for me to help troubleshoot this?

- Hammer

Request for Answer Clarification by bselltiz-ga on 06 May 2003 08:27 PDT
ya, I have some other grouping going on and apparently it is
interfering with my attempt to sort it. No big deal, I figured out a
work around using part of what you showed me before, so I'm good to
Thanks for your help, talk to ya soon :->

Clarification of Answer by hammer-ga on 06 May 2003 08:33 PDT
Excellent. Good luck with your deployment!

- Hammer
bselltiz-ga rated this answer:5 out of 5 stars
Hammer getting me what I need as usual :-> Thanks!

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy