 |
|
||||||||||
|
M.A.R.S |
||||||||||
|
This forum is for the sole use of MARS users. ChristianSteven Software will not accept any responsibility for the contents.
|
||
| Return to Website | ||
 First |
 Prev |
 Reply |
 Forum |
Next  |
Last  |
| Viewing Page 1 of 1 (Total Posts: 2) |
| Author | Comment |
|
Dean
Aug 9, 05 - 10:28 AM |
Dynamic parameter values
I need advice on the best method of providing paramters for dates. The access db is connected to a SQL database and we have a need for date driven paramters which we work out using the date function less a set number of days this doesn't seem to work through MARS (eg date() - 7) it simply does nothing using this. 
|
|
Mars Support
Aug 9th, 2005 - 10:31 AM |
Re: Dynamic parameter values
In Properties - Report, click the Advanced button. Is there anything there? If so, it will be your record selection formula. It will look something like this: Select *some data* from table where date = [?startdate] There are two ways of achieving what you want: 1. Modify the record selection formula in the Access report itself as follows: Select *some data* from table where date = date() - 7 This should remove the parameter prompt from the report. Schedule the modified report in MARS and it will always run as required without needing a parameter input from MARS. 2. Modify the record selection formula in the "Advanced" section in MARS replacing the parameter with the formula exactly as described above. MARS will use this version of the selection formula when running your report, leaving your original report intact for manual use should you want to. 
|
| First |
Prev |
Reply |
Forum |
Next |
Last |