Reminder Query

  • Thread starter mattc66 via AccessMonster.com
  • Start date
M

mattc66 via AccessMonster.com

Hi All,

I have a need to show records that are 3 month or older from a set date. How
would I wright a query to extract that data?
 
J

John W. Vinson

Hi All,

I have a need to show records that are 3 month or older from a set date. How
would I wright a query to extract that data?
Click to expand...

Put a criterion on the date field of

< DateAdd("m", -3, [the set date])
 
J

Jeff Boyce

Matt

Are you saying you want to see records where [YourDate] minus 3 months (or
more)? "Older" might be ambiguous -- do you mean AFTER or BEFORE
[YourDate]? Is [YourDate] a field in a table, or are you entering it as a
criterion?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

mattc66 via AccessMonster.com

It is the last date revised. The date is past and I want to see a list of all
items that are 3 months or more past that date.

Jeff said:
Matt

Are you saying you want to see records where [YourDate] minus 3 months (or
more)? "Older" might be ambiguous -- do you mean AFTER or BEFORE
[YourDate]? Is [YourDate] a field in a table, or are you entering it as a
criterion?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
Hi All,

I have a need to show records that are 3 month or older from a set date.
How
would I wright a query to extract that data?
Click to expand...
Click to expand...
 
J

Jeff Boyce

So, you have "items" that have "dates" and you want to see any that are more
than 3 months past "last date revised".

"How" depends on "what".

Describe your data structure and folks here may be able to offer more
specific suggestions about "how" to construct a query.

Regards

Jeff Boyce
Microsoft Office/Access MVP

mattc66 via AccessMonster.com said:
It is the last date revised. The date is past and I want to see a list of
all
items that are 3 months or more past that date.

Jeff said:
Matt

Are you saying you want to see records where [YourDate] minus 3 months (or
more)? "Older" might be ambiguous -- do you mean AFTER or BEFORE
[YourDate]? Is [YourDate] a field in a table, or are you entering it as a
criterion?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
Hi All,

I have a need to show records that are 3 month or older from a set date.
How
would I wright a query to extract that data?
Click to expand...
Click to expand...
Click to expand...
 
M

mattc66 via AccessMonster.com

Table:
Item DateLastReviewed
Widget1 11/12/2008
Widget2 08/06/2008

So if I ran a query I'd like to just see the Widget2 on the list since the
Widget1 is not more then 3 months.


Jeff said:
So, you have "items" that have "dates" and you want to see any that are more
than 3 months past "last date revised".

"How" depends on "what".

Describe your data structure and folks here may be able to offer more
specific suggestions about "how" to construct a query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
It is the last date revised. The date is past and I want to see a list of
all
Click to expand...
[quoted text clipped - 19 lines]
Click to expand...
 
J

John W. Vinson

Table:
Item DateLastReviewed
Widget1 11/12/2008
Widget2 08/06/2008

So if I ran a query I'd like to just see the Widget2 on the list since the
Widget1 is not more then 3 months.
Click to expand...

Put a criterion on DateLastReviewd of

< DateAdd("m", -3, Date())
 
Top