Date to show only the month

[Dennis Villareal]

I am trying to make a report that shows the production of a month. we enter
all the data in the table as a standard date. 2/1/09 like that. i want the
query to display only the Month Number like 2.

how can i accomplish this?

as a added bonus how can i get the Display to show the actual month

like if 2 show Feb. this will help make the reports look nicer.

thanks

 

[Rick Brandt]

I am trying to make a report that shows the production of a month. we
enter all the data in the table as a standard date. 2/1/09 like that.
i want the query to display only the Month Number like 2.

how can i accomplish this?

as a added bonus how can i get the Display to show the actual month

like if 2 show Feb. this will help make the reports look nicer.

thanks

For the number of the month you can use either...

=Month(FeildName)
or
=Format(FieldName, "mm")

For the month name...

=Format(FieldName, "mmmm")

 

[John W. Vinson]

I am trying to make a report that shows the production of a month. we enter
all the data in the table as a standard date. 2/1/09 like that. i want the
query to display only the Month Number like 2.

how can i accomplish this?

as a added bonus how can i get the Display to show the actual month

like if 2 show Feb. this will help make the reports look nicer.

thanks

Simply bind the date field to a textbox on the report; set the Format property
of that textbox to "m" to show 2, "mm" to show 02, "mmm" to show Feb, and
"mmmm" to show February. You're NOT limited to the predefined "canned" date
formats!

 

[Dennis Villareal]

thanks this worked great

For the number of the month you can use either...

=Month(FeildName)
or
=Format(FieldName, "mm")

For the month name...

=Format(FieldName, "mmmm")

 

[Dennis Villareal]

thanks. both these methods worked. i will have to store this in my notes.