Viewing SQL Statements

[gothung]

When I use the filter by form option to filter my query, it creates an SQL statement to tell the query what to use as filters. Is there anyway to show the SQL results in a text box in a report. An example SQL Statement looks like this:

SELECT *
FROM [Parts 2 Query]
WHERE ((([Parts 2 Query].Dept)=400) AND (([Parts 2 Query].Geography)="UNDERHOOD"));

The parts in Bold are the ones that I want to read into my report.

Can anybody help me with this?

 

[bat17]

do a search in help for "Print the criteria for a report in the report header" and see if this is what you need.
(found in A2K)

HTh

Peter

 

[gothung]

I looked into the help file and tried the suggestion that it gave me, the only problem is that you have to type in what it says in the text boxes. I want it to read in automatically from the SQL statement in the query. I purposly did not use this feature, because I wanted users to make their selections of criteria from drop down boxes in a form, to make it easier for them. With all that I get my data to read in perfectly, I would just like to have that criteria automatically read in, and since I am using the filter by form option, I figured that the only way to retrieve that would be through the SQl Statement. Please correct me if I am wrong, or if you have any other options to try.

Thanks

Dan

 

[bat17]

You can link fields in your report directly to the dropdown boxes in the form to get the values from them.

Peter

 

[gothung]

Because I am using the "filter by Form" option to make the selections, it requires me to turn off the the filter before I can close the form. When I open my report all I see in those text boxes are: #Name?

 

[SydneyGeek]

Don't close the form before running the report -- hide it instead, and then close it when the report closes (use the Close event of the report). That way, you have full access to the field values in the form.

Denis

 

[gothung]

Even if I minimize the window without closing it, it still does not put those values into the report.