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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

help running a report over a week period without parameters

Status
Not open for further replies.

tazibc

Instructor
Oct 5, 2007
66
GB
Hi All, an anyone help.....

I have a report that I need to run over a week period without the use of a parameter. I need to know how to create a formula that could be implemented into a record selection.

{weekly hub date} is the field can any one help with this please
 
YOu can use function currentdate which returns date report excuted.

{weekly hub date}<= currentdate and
{weekly hub date}> currentdate-7

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top