By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,066 Members | 1,826 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,066 IT Pros & Developers. It's quick & easy.

Wk Range Across Multiple Years

P: n/a
I'm trying to create a query that will run with criteria that includes
the most recent eight weeks of data (by week number). The problem that
I can't get around is how I handle the first 7 weeks of a new year.
The current way that I generate my eight week trend is to take the most
recent week number (from a tbox in a form which returns the most recent
week #) & use a statement which says: 'Between (wk#) and (wk# - 8)' ,
which will work except during those first 7 weeks. What I want is for
the query to go back to the previous year & include the necessary weeks
to complete the eight week trend. I've thought of a few different very
complicated options, but this can't be that tough, Can IT? Any help
would be much appreciated!!


Aug 22 '06 #1
Share this Question
Share on Google+
1 Reply

P: n/a
use DateDiff instead. Then you can add and subtract weeks across
years. Doesn't matter at all.

Aug 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.