Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help: Display a calculated value from query

Status
Not open for further replies.

kull

Technical User
Aug 2, 2000
7
CA
Hi Folks

Does anyone know how I can do this:

I have a report that displays client data based on a query which allows the user to choose to display data beteen two distinct dates. This part works. However, I would like to have the report display the two dates that the user entered. How do you do this since the dates entered can't be sourced in a table or query when using a text box on the report. Maybe it is possible to source that data from the query involved, but how do you word the expression to do this? Any suggestions?

Steve
kull@canoemail.com
 
Set up a text box in your report that has as its control source something like this, but the parameters have to be named exactly like yours are in your query:
Code:
="Between " & [Enter Beginning date] & " and " & [Enter Ending date]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top