Showing Search Criteria

[dan.cawthorne]

Hello,

I don't know if this is a easy task or a Hard Task.

But I Have a Query That Filters Out a Search Via a Date Field

Which A User in a dialog (which has to unbound text boxes) types 2
Dates, and the query then lists all The Projects Between those Dates.


That Works Great,

And Ive Created a Report That Shows Those Searched Results,

What I Would Like Is on the Report To Be able to Show The 2 Dates The
User Searched Between, so When any one is viewing the report they know
that the projects are only between those dates?

Can This Be Done?

Regards

Dan

 

[Douglas J. Steele]

Simply refer to the criteria in the report.

If your query is

SELECT Field1, Field2, Field3
FROM Table1
WHERE Field1 BETWEEN Forms!Form1!Text1 AND Forms!Form1!Text2

your report can have a text box with a ControlSource of

="Data retrieved between " & Forms!Form1!Text1 & " and " & Forms!Form1!Text2

And at the risk of being annoying, I'll once again ask that you please stop
your bizarre method of capitalizing each word. It makes your posts much
harder to read!

 

[dan.cawthorne]

Simply refer to the criteria in the report.

If your query is

SELECT Field1, Field2, Field3
FROM Table1
WHERE Field1 BETWEEN Forms!Form1!Text1 AND Forms!Form1!Text2

your report can have a text box with a ControlSource of

="Data retrieved between " & Forms!Form1!Text1 & " and " & Forms!Form1!Text2

And at the risk of being annoying, I'll once again ask that you please stop
your bizarre method of capitalizing each word. It makes your posts much
harder to read!

Thank you Doug Steele,

the code works great,

Sorry about the capital letters at the each word its an habit, i'm
trying to get out of lol.