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

Jumat, 08 Februari 2013

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

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
>
>
>