Date selection

  • Thread starter Thread starter JD
  • Start date Start date
J

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?
 
You could add the full date to the combo box, give it a 0 (zero) display
width and sort on that field.
 
Back
Top