Combine 3 fields

  • Thread starter Thread starter Vic
  • Start date Start date
V

Vic

I need to take a Month field, a Day field, and a Year
field and combine them into one field. I can not get
this to work. Any ideas.

Thanks
 
I need to take a Month field, a Day field, and a Year
field and combine them into one field. I can not get
this to work. Any ideas.

Thanks
Click to expand...

If the fields all contain numbers (e.g. Month = 7, Day = 23, Year =
2004 for today), use

DateSerial([Year], [Month], [Day])

Note that all three fieldnames are reserved words. You should at the
very least always use square brackets to keep Access from getting
confused; better would be to change the fieldnames.
 
Back
Top