[b][u]How do you include query criteria in a report?[/u][/b]

[userjf]

How do I show all of the criteria used in my query in a report? I would like to place this information at the top or end of the report so that once it is distributed to my development officers they can see the criteria & query name and request a refresh of same. I'd like to see:

1. Query Name
2. Any field that has query criteria:
[Field #7] Is Null
[Field #9] Like "E*"
3. Join & SQL information
4. Query properties
Unique values: Yes; Records Type: Snapshot; ODBC Timeout: 0

This information placed at the top or the bottom of a report would be invaluable whenever we process ad-hoc requests. It would tell what the previous criteria was, tables used and the SQL statement.

 

[sfreeman]

Might help with one of your questions...

You can diplay the parameter information by adding a text field and setting its Control Source to the parameter prompt.

For example, if your user is prompted in the query for a city parameter 'Enter City', then set the Control Source to
"=[Enter City]".

HTH

Sam_F
"90% of the problem is asking the right question.

 

[traingamer]

Pick up this thread in thread702-1034958 so people aren't repeating answers from double posting.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill