Problem with Text/Date fields in expression builder 1

[elaineva]

I've made new fields for my report using the expression builder and it always works great with text fields or date fields - but I get errors if I try to mix text and date fields.

Example that works:
="This report has been designed by " + [NameField] + " and it works great"

Example that does not work:
="This report has been designed by " + [NameField] + " on " + [Datefield] + " and it does not work"

Any ideas??

 

[dhookom]

Don't use "+" if you want to concatenate text/string values. Use "&". There are specific instances where you will want to use "+" but this is rare.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[elaineva]

Thanks so much.....works great!!