|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
December 28th, 2004, 02:54 PM
|
|||
|
|||
|
How to insert a criteria from query into report
I am trying to insert the dates used as a criteria in a query into a report without having to type them every time. The criteria is:
Between ([Please enter starting date]) And ([Please enter ending date]). This is entered once to launch the report however I would like these dates to appear in the header without having to manually change them each time. I appreciate any suggestions. Thomas
|
|
#2
December 29th, 2004, 07:56 AM
|
|||
|
|||
|
Just put a textbox in the header with the control source as
Code:
=[Please enter starting date]) & " to " & [Please enter ending date] This will automatically populate those bracketed variables when it asks for the query.
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > How to insert a criteria from query into report |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
