Parameter Query query

[SDS100UK]

Hi,

Is it possible to construct a parameter query using BETWEEN and AND that automatically adds 5 days on to the first (and only) prompt to the user??

Something like:

Between [Week Commencing] And ([Week Commencing +5])

The above line does not work though!

Any ideas?
Thanks
Steven

 

[THoey]

You need to move the +5 outside of the square bracket... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.