Date selection

[JD]

I have a combo box in a form to select a month (from a
list) to assign to each record. The report sorts records
by this month field. The problem I recently ran into is
going across a different year. Naturally, January is
always listed first. But I need November & December
listed ahead of January.

I know I can set up a date field and input the actual
date, but I was looking for a way to keep the combo box.
I was wondering if there was some command I could use that
would tell access to assume any month prior to the current
month is actually in the next year.

Can anyone help with this?

 

[hal boyles]

You could add the full date to the combo box, give it a 0 (zero) display
width and sort on that field.