Automatic Updating Report Numbers

[Windsor302]

Hey there, I am required to submit reports on my accumulated data every 2 weeks, I was wondering if tehre is a way to insert a report # in the header that will automatically update itself. Thanks.

 

[plog]

Set a control equal to this:

=Int(DateDiff("d","7/5/2011",Date())/14)+1

And replace "7/5/2011" with the date you run report #1. Also, if you can't run this early or it will reproduce the last report #.

 

[Windsor302]

Thanks a lot