Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pretoria
Starting Member
6 Posts |
 Posted - 2005-08-01 : 09:05:41
|
| Does anyone have an idea how I could include criteria I input in a query to that of a report?I have a date stamp in a query. In that query I entered the BETWEEN [ENTER START DATE:] AND [ENTER END DATE] paramater. In the report this query is based on I would like to include as header of that report the two dates I entered in the criteria parameter field dynamically entered.thanks. |
|
|
Meltdown
Starting Member
37 Posts |
Posted - 2005-08-01 : 22:03:19
|
| Parameters can be accessed like fields, put 2 unbound text boxes on the report and set the Control Source to...=[ENTER START DATE:]=[ENTER END DATE]...should be the exact name of your parameters. |
 |
|
|
pretoria
Starting Member
6 Posts |
Posted - 2005-08-02 : 05:31:50
|
| perfect thanks! |
|
|
|
|
|
|
including criteria parameters in report