Query input parameters inputted onto a report

[lbradbury]

Hello,

I have a report that is generated based off a of a query of inputted parameters with a start and end date to query records. I'd like the inputted parameters to appear on the report to show the user what they have set for the start/end dates.

Thanks,

 

[Joe4]

Are you using a Parameter Query? If so, I think it may be difficult to do that.
Instead, create a Selection Form where you enter that criteria, and have those two entries bound to a one-record table (that stores the last inputted values).
Then you could reference the values from that Table on the Report.

 

[welshgasman]

If I understand you correctly, you could do something like this, then refer to sDate and Edate in your report.
The StartDate and EndDate are input when the query runs?

SELECT Transactions.*, Transactions.TRansactionDate AS TransactionDate1, Transactions.TransactionDate, [StartDate] AS SDatte, [EndDate] AS EDate
FROM Transactions
WHERE (((Transactions.TRansactionDate)>=[StartDate]) AND ((Transactions.TransactionDate)<=[EndDate]));

You of course choose your fields, I just selected all in my test. Could also use Between?

SELECT Transactions.*, Transactions.TRansactionDate AS TransactionDate1, [StartDate] AS SDatte, [EndDate] AS EDate
FROM Transactions
WHERE (((Transactions.TRansactionDate) Between [StartDate] And [EndDate]));

HTH