Sorting Months

You didn't say what you data source is. Assuming it's a date/time field,

try sorting by format([NameofYourDateTimeField],"mm")

I completely forgot the source! There is a field in the table that has the
months listed that corresponds to the date in another field. If I insert the
date, then it gives me a daily report. I need the information on a monthly
basis.

"Fred" wrote:

You didn't say what you data source is. Assuming it's a date/time field,

try sorting by format([NameofYourDateTimeField],"mm")

Assuming that that other field is a Date/Time field, I'd try what I gave you,
putting your date/time field name, (not your field with the month text)

BTW you probably shouldn't have that month field......just derive get the
month text from your date/time field when needed via an expression.

I have added numbers 1-12 in the mean time to get it to sort correctly,
however, it looks tacky.
You do not have to display what you sort by.
--
KARL DEWEY
Build a little - Test a little


"Fred" wrote:

Assuming that that other field is a Date/Time field, I'd try what I gave you,
putting your date/time field name, (not your field with the month text)

BTW you probably shouldn't have that month field......just derive get the
month text from your date/time field when needed via an expression.