How can I display a date and time next to eachother in an expression?

[sirantonycartwr]

I want this expression to form a value of a field on a query...

I know that what I want is something like this:

arrangedActivityName: [activityDate]+", "+[activityTime]+", "+[activityId]+", "+[venueName]

When I do it though, its shows "#Error" in the field.

I'm guessing that its something to do with the fact that date and time are not strings or ints therefore cannot be displayed. How can I fix this?

Does anyone know how I can do it?

Thanks, Ant...

 

[Mike375]

[activityDate] & " " & [activityTime] & " " & [activityId] & " " & [venueName]

 

[sirantonycartwr]

Thank-you!
Thats it!
Ant...