Beginner Question - Month Field

[KT]

I imported an Excel table into Access in which the year, month and date are
in separate fields. The month field was formatted as text, i.e. "July", but I
couldn't generate a report by month in order from Jan - Dec, so I replaced
the month name with it's associated number and changed the field format to
number.

What I really want is to generate reports that are grouped by month, but I
want the month name to show, not the number. Which is the simplest way for me
to achieve this?

Thank you!

 

[boblarson]

Leave the grouping by the month, but for the text box that displays the Date,
use the format:

=Format([YourDateField],"mmmm")
--
Bob Larson
Access World Forums Super Moderator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[KARL DEWEY]

There is the simplest way and there is the best way.
Simplest is to create a translation table --
MM - number
Mon - Text - three character
Month - text - full spelling
In your query join your month's field to the MM field and add the Month
field as an output.

The best way is to create a DateTime field in your Table and run an update
query.
DateSerial([YourYearField],[YourMonthField],[YourDateField])
Then you can format the date anyway you want it for display and summing up
weeks, months, quarters, or years.

 

[KT]

Thank you, this worked like a charm. I appreciate your help!

KT

There is the simplest way and there is the best way.
Simplest is to create a translation table --
MM - number
Mon - Text - three character
Month - text - full spelling
In your query join your month's field to the MM field and add the Month
field as an output.

The best way is to create a DateTime field in your Table and run an update
query.
DateSerial([YourYearField],[YourMonthField],[YourDateField])
Then you can format the date anyway you want it for display and summing up
weeks, months, quarters, or years.
--
KARL DEWEY
Build a little - Test a little

I imported an Excel table into Access in which the year, month and date are
in separate fields. The month field was formatted as text, i.e. "July", but I
couldn't generate a report by month in order from Jan - Dec, so I replaced
the month name with it's associated number and changed the field format to
number.

What I really want is to generate reports that are grouped by month, but I
want the month name to show, not the number. Which is the simplest way for me
to achieve this?

Thank you!