Lensmeister
Registered User.
- Local time
- Today, 20:18
- Joined
- Feb 18, 2009
- Messages
- 65
Hi,
I want to query a table in Access 2003.
I have set up the query and under criteria I need to to just select the items that are due for review. the items that need to be reviewed need to be done 21 days prior to the expiry date.
i.e.
Item 1 expiry date = 31/07/2015. The query would show this up on 10/07/2015 and all those items that need reviewing as well.
Item 2 expiry date = 10/06/2015 would also show up.
I read http://www.access-programmers.co.uk/forums/showthread.php?t=132555
and I think that in the review date criteria I need to use some sort of calculation like in that thread above.
Can anyone advise please?
EDIT:
I came across this;
therefore I think if I use this
it should work.
Am I right?
I want to query a table in Access 2003.
I have set up the query and under criteria I need to to just select the items that are due for review. the items that need to be reviewed need to be done 21 days prior to the expiry date.
i.e.
Item 1 expiry date = 31/07/2015. The query would show this up on 10/07/2015 and all those items that need reviewing as well.
Item 2 expiry date = 10/06/2015 would also show up.
I read http://www.access-programmers.co.uk/forums/showthread.php?t=132555
and I think that in the review date criteria I need to use some sort of calculation like in that thread above.
Can anyone advise please?
EDIT:
I came across this;
Code:
SYNTAX - DateAdd(interval, number, date)
Code:
expr1: DateAdd('d', -21, [fieldname])
Am I right?
Last edited: