Filters in sub query

  • Thread starter Thread starter Arthur Weiner
  • Start date Start date
A

Arthur Weiner

I have a sub query in which there are parameter values to
enter from the main query. The values are not fields in
the resulting sub query. I want to show the parameter
values in my report, but they are not in the query from
which I am reporting.

Thank you.

Artie Weiner
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Create a TextBox control on your report. Put something like this in
its ControlSource property:

=[Parameter Prompt:]

If the name of the query parameter is [Parameter Prompt:] its value
will be shown in the TextBox when the report runs.

If the parameter is a reference to a Form control the report control's
ControlSource property would be like this:

=Forms!FormName!ControlName

HTH,
- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQB6p64echKqOuFEgEQKYxACbBe/M/A70BK8p62I6UBk7a3mD/joAoJeN
3Yzf9x+0DPuGCBKq+QYT2nWV
=kxUx
-----END PGP SIGNATURE-----
 
Back
Top