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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Vba to change displayed year automatically. 14
Setting a date field using combo box 3
Button to navigate/Filter records from month to month and year to 1
Subtract a year 2
A month selector 1
Mapping strings to integers 5
How can I update a second field from a Combo Box? 12
Setting combo box default value 1

Back
Top