Google Answers Logo
View Question
 
Q: Access Report - Query Parameter ( No Answer,   0 Comments )
Question  
Subject: Access Report - Query Parameter
Category: Computers > Programming
Asked by: bselltiz-ga
List Price: $26.00
Posted: 27 Oct 2003 12:55 PST
Expires: 03 Nov 2003 09:27 PST
Question ID: 270194
I have a report that I open from code. The report is bound to a stored
query. It is an aggregate query with 5 fields that show up on the
report, 3 are grouped and 2 are summed. The query also has 2 fields
that don't show in the result that are used to specify criteria. This
criteria is known at design time and is coded into the query. I need
to learn how to supply a 3rd criteria who's value will not be known
until I call the open report command from code. I don't want this 3rd
criteria to be part of the query's result set, which would alter my
grouping results. How do I supply this parameter to the query using
code, when opeing the report?
Thanks,
Brian
Answer  
There is no answer at this time.

Comments  
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 answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


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