Bookreader <bookreader127@yahoo.com> wrote in
news:j2ndc1d4uld8i9f794eivb3j9kloaattcd@4ax.com:
[color=blue]
> On Wed, 26 Jan 2005 03:27:05 GMT, fredg
> <fgutkind@example.invalid> wrote:
>[color=green]
>>On Wed, 26 Jan 2005 03:07:43 GMT,
tommy@yahoo.com wrote:
>>[color=darkred]
>>> I am working with the Invoice report in the Northwind sample
>>> database.
>>>
>>> How can I see the SQL statement that provides the data to
>>> the report?
>>>
>>> Thanks.[/color]
>>
>>Open the report in Design View.
>>Show the report properties window.
>>Click on the Data tab.
>>The first property is RecordSource.
>>Click on that line, then click on the button with the 3 dots
>>that appears.
>>That opens the QBE query window. Click on the View tool button
>>arrow. Select SQL.[/color]
>
> When I try to do this I only see ControlSource in the Data
> section. Am I using the right tool.
>[/color]
After you opened the report in design view you clicked on
something (a control) you were not instructed to above before
opening the properties window.
[color=blue]
> When you say "Show the report properties window." do you mean
> click the properties for the field I want to see? Or do you
> mean that I should be able to get properties for the report
> itself. Because I can't find anything like that.[/color]
He meantproperties for the report itself.
To get back to the report itself, after having clicked a
control, find a little square in the frame at the intersection
of the horizontal and vertical rulers. Click once, a little
black square appears, and the properties change to those of the
form/report.
[color=blue]
>
> Thanks.
>[/color]
Welcome.
--
Bob Quintal
PA is y I've altered my email address.
