Monthly

F

fajita

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

Rick B

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

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