Re: How do I get parameters printed on report when query not attached
- From: "Ken Snell \(MVP\)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 7 Sep 2006 16:50:18 -0400
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?
.
- Prev by Date: Re: Format Date with Text
- Next by Date: Re: How do I get parameters printed on report when query not attached
- Previous by thread: Re: Format Date with Text
- Next by thread: Re: How do I get parameters printed on report when query not attached
- Index(es):
Relevant Pages
|
|
