Monthly

  • Thread starter Thread starter fajita
  • Start date Start date
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?
 
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?
 
Back
Top