Concatenating date field to text field (1 Viewer)

[SDLevy]

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

 

[Pat Hartman]

Looks OK except that you should use the ampersand (&) as the concatenation operator rather than the plus sign (+) unless you need the special properties of the plus sign.

 

[SDLevy]

thanks

Hello,

Switching from + to & solved my problem.

I hadn't realized there was a difference between the two. I looked them up in a reference book and now it makes sense.

My form combo box works like a charm now.

Thank you.

Susan