Date Recurrence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Assuming that I have a table with all the dates for a year how do I write a
query to return every date 7 days from a specified date? Thanks in advance
for your help.
 
Make a calculated field in the query. If the "specified date" changes from
time to time, you might use a parameter or refer to a text box in a form that
contains the date. My example will use a parameter:

Calculated field SevenDays: ABS([Enter Specified Date] - [DateField])
This will return the number of days between the two dates (assuming you
aren't storing time data as well)
 
Back
Top