Multiple Fields in One - Text AND Number

[Heath]

I have the following Expression in a query putting 3
fields into one.

Details: [books]![title]+" "+[books]![publisher]+", "+
[books]![notes]

I also need another field called "year" (number field),
however when I enter:

Details: [books]![title]+" "+[books]![publisher]+", "+
[books]![year]+", "+[books]![notes]

I go back to the Datasheet View and get "#Error".
My feeble mind is telling me that this isn't working
because 3 fields are 'text' while the year is 'number'.

Is there a way to display all of these in the same field,
or will I have to put the year in a seperate section of
the report it will eventually be a part of?

Any ideas welcome,
Thanks,

Heath
Primary = (e-mail address removed)
Secondary = (e-mail address removed)

 

[Dan Artuso]

Hi,
Try using the & character instead of +.

 

[Art]

Cstr([books]![year]) should convert the number to text.