Access Date Problem

[amdzw]

I need help. :idea:
It's probably something so simple, but is it possible to have a query for "Week Ending"
I.E. if you input a date and it calculates 7 dates before and shows the results. something like
"-7<=[Enter Date]"
instead of using the "Between[Date]And[Date]"
Much Appreciated

[harryjo]

Daer,

Hopely this will help

In Access, the DateAdd function returns a date after which a certain time/date interval has been added.

The syntax for the DateAdd function is:

DateAdd ( interval, number, date )

interval is the time/date interval that you wish to add. It can be one of the following values:

Value Explanation

yyyy Year
q Quarter
m Month
y Day of the year
d Day
w Weekday
ww Week
h Hour
n Minute
s Second

number is the number of intervals that you wish to add.

date is the date to which the interval should be added.

For example:

DateAdd ('yyyy', 3, #22/11/2003#) would return '22/11/2006'
DateAdd ('q', 2, #22/11/2003#) would return '22/05/2004'
DateAdd ('m', 5, #22/11/2003#) would return '22/04/2004'
DateAdd ('n', 51, #22/11/2003 10:31:58 AM#) would return '22/11/2003 11:22:58 AM'
DateAdd('yyyy', -1, #22/11/2003#) would return '22/11/2002'

Best regards Harry