ACCESS FEED: RE: [MS_AccessPros] How to find "This Month"

Sabtu, 09 Februari 2013

RE: [MS_AccessPros] How to find "This Month"

Thanks John,

That is perfect.

Cheers,

Robin

At 9/02/2013 10:11 PM, you wrote:
>Robin-
>
>Like this:
>
>WHERE Format([MonthDate],'yymm') = Format(DateAdd("m", -1, Date()),'yymm')
>
>John Viescas, Author
>Microsoft Access 2010 Inside Out
>Microsoft Access 2007 Inside Out
>Microsoft Access 2003 Inside Out
>Building Microsoft Access Applications
>SQL Queries for Mere Mortals
>http://www.viescas.com/
>(Paris, France)
>
>
>
>
>-----Original Message-----
>From: MS_Access_Professionals@yahoogroups.com
>[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
>Sent: Saturday, February 09, 2013 11:26 AM
>To: MS_Access_Professionals@yahoogroups.com
>Subject: RE: [MS_AccessPros] How to find "This Month"
>
>
>Thanks Duane,
>
>I found the page on the Microsoft site but the implementation is far beyond
>my very limited capabilities.
>
>Robin Chapple
>
>At 9/02/2013 04:24 PM, you wrote:
> >Consider using the DateAdd() function to add or subtract a month to an
> >expression or field.
> >
> >Duane Hookom MVP
> >MS Access
> >
> >----------------------------------------
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: robinski@mymail.net.au
> > > Date: Sat, 9 Feb 2013 16:05:36 +1100
> > > Subject: RE: [MS_AccessPros] How to find "This Month"
> > >
> > >
> > > Many thanks Graham,
> > >
> > > That is perfect. I've got a suspicion that the request should have
> > > been for "Last Month". What changes are needed if I am asked that
>question?
> > >
> > > Best wishes,
> > >
> > > Robin
> > >
> > > At 9/02/2013 03:35 PM, you wrote:
> > > >Hi Robin
> > > >
> > > >This should do the trick:
> > > >
> > > >... WHERE Format([MonthDate],'yymm') = Format(Date(),'yymm')
> > > >
> > > >or this:
> > > >
> > > >... WHERE (Year([MonthDate])=Year(Date()) AND
> > > >Month([MonthDate])=Month(Date()))
> > > >
> > > >Best wishes,
> > > >Graham
> > > >
> > > > > From: MS_Access_Professionals@yahoogroups.com
> > > >[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
> > Robin Chapple
> > > > > Sent: Saturday, 9 February 2013 17:14
> > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > Subject: [MS_AccessPros] How to find "This Month"
> > > > >
> > > > > I have a table with records date stamped with a 'Date' field
> > - "MonthDate"
> > > > >
> > > > > I need to add criteria to a query that will supply "This Month"
>only.
> > > > > All my attempts have failed.
> > > > >
> > > > > How do I select records for "This Month"?
> > > > >
> > > > > Many thanks,
> > > > >
> > > > > Robin Chapple
> > > >
> > > >
> > > >
> > > >
> > > >------------------------------------
> > > >
> > > >Yahoo! Groups Links
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
> >
> >------------------------------------
> >
> >Yahoo! Groups Links
> >
> >
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>