I need to link data on an existing weekly report. My problem is that the data crosses over 2 weeks. This dataset is measured from Wednesday to Tuesday. However, I need to link all the data with the Saturday in between the Wednesday and Tuesday. Any Suggestions... please help.
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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need help writing a date function
- Thread starter Sdaddy
- Start date
mscallisto
Technical User
I'm not sure I understand the problem, you may need to give another example.
Can you use the function
DAYS360(start_date,end_date,method)
to test if the distance between dates is seven?
Can you use the function
DAYS360(start_date,end_date,method)
to test if the distance between dates is seven?
MichaelRed
Programmer
Days360? Excel? but ... but ... but ... isn't the question askeck in the MS Access CODING forum?
A visit to DateDiff | DateAdd | other Date functions might yield a number of soloutions
MichaelRed
m.red@att.net
Searching for employment in all the wrong places
A visit to DateDiff | DateAdd | other Date functions might yield a number of soloutions
MichaelRed
m.red@att.net
Searching for employment in all the wrong places
mscallisto
Technical User
Sorry....Pressed the wrong button!!
("`-''-/"
.___..--''"`-._
`6_ 6 ) `-. ( ).`-.__.`)
(_Y_*.) ._ ) `._ `. ``-..-'
_..`--'_..-_/ /--'_.' ,'
(il), '' (li),' ((!.-'
("`-''-/"
.___..--''"`-._ `6_ 6 ) `-. ( ).`-.__.`)
(_Y_*.) ._ ) `._ `. ``-..-'
_..`--'_..-_/ /--'_.' ,'
(il), '' (li),' ((!.-'
- Status
Similar threads
- Locked
- Question
- Locked
- Question
