Re: Converting dates from 3-column to single column
To display in a query you could use
NewFieldNameHere:[MonthFieldNameHere] & "-" & [DayFieldNameHere] & "-" & [YearfieldNameHere]
or you could convert it to a date by using
DateSerial ([YearFieldNameHere], [MonthFieldNameHere], [DayFieldNameHere]
It all depends on what you are planning to use it for. (plus it isn't the best to store dates in that broken out of format unless you absolutely have to.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.