Re: How do I get parameters printed on report when query not attached

Include the parameters as calculated fields in the query, and then bind
controls in the report to those calculated fields:

SELECT T.*, [First Parameter] AS FPar,
[Second Parameter] AS SPar
FROM TableName AS T
WHERE T.FieldName1 = [First Parameter] And
T.FieldName2 = [Second Parameter];

--

Ken Snell
<MS ACCESS MVP>

"Denise D" <Denise D@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:20004290-4DC0-44D4-9C2D-B48AE81A1050@xxxxxxxxxxxxxxxx
I have to create six queries just to get my data manipulated for my report.
The problem is that I have to prompt the user for parameters in the third
query and I need to print those parameters on the sixth report query. Any
suggestions?


.

Relevant Pages

  • Re: String Used in Report Displays as Garbage
    ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... When I simply open the query directly I see the field values exactly as I ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)
  • Re: Expression error when running report, but not in query.
    ... And both expressions calculate correctly on every record. ... Another weird thing is that the 1st report works correctly off it's query. ... > Calculated fields misinterpreted ...
    (microsoft.public.access.reports)
  • Re: String Used in Report Displays as Garbage
    ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)
  • Re: Hiding details
    ... >I have report based on the query with some calculated fields. ... I have tried to filter query by ...
    (microsoft.public.access.reports)
  • Format a calculated field from query on report??
    ... Create a simple query based on your calculated query and ... > I have a report whose record source is a query. ... calculated fields, without success. ... no options for the Format field. ...
    (microsoft.public.access.reports)