Converting date value from number to string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a combo box that lists the numbers 1 to 12. Each number represents a
month. This is the only way I can get my query to understand that '5' means
all records with 05 as the month. How can I get the query to understand that
"May" means 05? All I want is to have my combo box displaying more friendly
month names rather than numbers.

I am using Microsoft Access. Really what I want is a new column in my query
that converts strings to numbers.

Thanks!
 
Set these properties for your combo:

RowSourceType: Value List
Row Source: 1;"Jan";2;"Feb";3;"Mar";4;"Apr";5;"May";6;"Jun"...
Column Count 2
Column Widths: 0

The combo is made up of a list in 2 columns, with the first column
zero-width so it displays the 2nd one.
 
Thanks! That worked perfectly.

Allen Browne said:
Set these properties for your combo:

RowSourceType: Value List
Row Source: 1;"Jan";2;"Feb";3;"Mar";4;"Apr";5;"May";6;"Jun"...
Column Count 2
Column Widths: 0

The combo is made up of a list in 2 columns, with the first column
zero-width so it displays the 2nd one.
Click to expand...
 
Back
Top