Reminder Query "mattc66 via AccessMonster.com" <u16013[ at ]uwe> 12/24/2008 6:36:51 PM 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? -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200812/1

Re: Reminder Query John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/24/2008 6:55:51 PM On Wed, 24 Dec 2008 18:36:51 GMT, "mattc66 via AccessMonster.com" <u16013[ at ]uwe> wrote: [Quoted Text] >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? Put a criterion on the date field of < DateAdd("m", -3, [the set date]) -- John W. Vinson [MVP]

Re: Reminder Query "Jeff Boyce" <nonsense[ at ]nonsense.com> 12/24/2008 6:57:01 PM 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 "mattc66 via AccessMonster.com" <u16013[ at ]uwe> wrote in message news:8f270c8b3e31d[ at ]uwe... [Quoted Text] > 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? > > -- > Matt Campbell > mattc (at) saunatec [dot] com > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200812/1 >

Re: Reminder Query "mattc66 via AccessMonster.com" <u16013[ at ]uwe> 12/24/2008 7:06:13 PM 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 Boyce wrote: [Quoted Text] >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? -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200812/1

Re: Reminder Query "Jeff Boyce" <nonsense[ at ]nonsense.com> 12/30/2008 4:58:30 PM 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" <u16013[ at ]uwe> wrote in message news:8f274e268e845[ at ]uwe... [Quoted Text] > 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 Boyce wrote: >>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? > > -- > Matt Campbell > mattc (at) saunatec [dot] com > > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200812/1 >

Re: Reminder Query "mattc66 via AccessMonster.com" <u16013[ at ]uwe> 12/30/2008 6:21:28 PM 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 Boyce wrote: [Quoted Text] >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 >[quoted text clipped - 19 lines] >>>> How >>>> would I wright a query to extract that data? -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200812/1

Re: Reminder Query John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/31/2008 1:10:33 AM On Tue, 30 Dec 2008 18:21:28 GMT, "mattc66 via AccessMonster.com" <u16013[ at ]uwe> wrote: [Quoted Text] >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. Put a criterion on DateLastReviewd of < DateAdd("m", -3, Date()) -- John W. Vinson [MVP]