Help with int to string

[gnibbles]

I have a report that I want to have a from "Month" to "Month" in  and im getting the from and to results from a drop down box in a form but it's using the ID field instead of the actual month and I want to change the number to the actual month. Im trying to use if else statements to change the number to a string but it wont let me. if someone could help Id appreciate it thanks guys/girls.

 

[elizabeth]

For getting just the Month from a complete date, check out Access's built-in <b>DatePart</b> function. If you mean you have a table with 2 fields, the number (1,2,3...) is the ID and the name (Jan, Feb...) is the name, and you're getting the ID but wasnt to display the name, set the combo's Column Count property to 2 and the Column Widths property to 0;1 and the combo will display the second column in the underlying query/table in a 1-inch wide column and not display the ID column because&nbsp;&nbsp;of the width of zero.

 

[Amiel]

<br>When you use the list box wizard, it will prompt you for the value to be used later to perform whatever actions you choose to perform with the selected value. This number (the column position) becomes the 'bound column' property.<br><br>With what you have now you should be able to change the bound column property to the date field in the list box.<br><br>Note: The Key field , default name 'ID', is usually at position 1 <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>