Beginner Question - Month Field

  • Thread starter Thread starter KT
  • Start date Start date
K

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!
 
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

__________________________________
 
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.
 
Thank you, this worked like a charm. I appreciate your help!

KT

KARL DEWEY said:
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


KT said:
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!
Click to expand...
Click to expand...
 
Back
Top