Re: Monthly

From: Rick B (anonymous_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 15:15:19 -0500

you need to create a new column with the following in the Filed...

MonthOfDate: DatePart("m",[FieldNameHere])

In the criteria, put which month you want to pull.

Rick B

"fajita" <anonymous@discussions.microsoft.com> wrote in message
news:229c701c45e0e$71b50ba0$a601280a@phx.gbl...
I have an input date in my query EX: 3/5/03 and would
like to pull up by month, what could i use in the
critiera to do this? do i need to change format of date?

Relevant Pages