Date Field to Month Field

[Canadiangal]

I have a field in Access called Date. I have a query attached to a form that allows the end user to enter data. Right now they enter the Date field, and then they have another field called month which they fill in manually. So 12/5/1963 would be in the Date Field, and the Month Field would be 12. What calculation can I put in that would copy the Month from the Date field and put it into the Month Field.

[pbaldy]

For starters, date is a bad field name as Access can confuse it with the Date() function. Why would you save the month when it is so easily derived from the date field? I wouldn't save it, but the Month() function would be used either way.

[burrina]

What is the format of your date field (s)? short date? And, do you want a numeric value such as 01 or January? for the end result?

I used Text0 and Text4 for my date fields with Text0 being the date field the user enters a date into. with the format being short date and Text4 having NO format and its default value set to: =DatePart("m",[Text0]) and this gives you the month in numeric value. Hope this helps, unsure if what exactly you want!???

[Canadiangal]

Thanks Paul, that did the trick. The month field is used on another query.

[pbaldy]

Happy to help!