Hello,
I'm trying to put a function in my query to concatenate a date field and text field. I looked high and low and can't seem to get this to work. Is it because concatenation is just for text fields?
Obviously I am rather new at this, so I do apologize if this is too basic a question.
I have a table - Events, with the fields : EventName and EventDate, the first defined as a text field and the second being a date field.
In my query I tried to define the following:
EventNameDate: [EventName]+[EventDate]
and I get an #Error
Did I mess up in my original naming in my table or is it in my concatenation?
Thank you,
Susan
I'm trying to put a function in my query to concatenate a date field and text field. I looked high and low and can't seem to get this to work. Is it because concatenation is just for text fields?
Obviously I am rather new at this, so I do apologize if this is too basic a question.
I have a table - Events, with the fields : EventName and EventDate, the first defined as a text field and the second being a date field.
In my query I tried to define the following:
EventNameDate: [EventName]+[EventDate]
and I get an #Error
Did I mess up in my original naming in my table or is it in my concatenation?
Thank you,
Susan