The company I work for have recently upgraded PC's to Office 2010 from 2003. I am getting some errors in my database which I am dealing with one at a time.
The latest is when I run a particular report I am receiving an error saying
Undefined function 'Chr' in expression
Below is the expression
SiteAddress: [Name] & (Chr(13)+Chr(10)+[Address1]) & (Chr(13)+Chr(10)+[Address2]) & (Chr(13)+Chr(10)+[Address3]) & (Chr(13)+Chr(10)+[Town]) & (Chr(13)+Chr(10)+[tblsurveyenquiry].[County]) & (Chr(13)+Chr(10)+[Postcode])
If anyone can help, it would be much appreciated.
Thanks
Richard
The latest is when I run a particular report I am receiving an error saying
Undefined function 'Chr' in expression
Below is the expression
SiteAddress: [Name] & (Chr(13)+Chr(10)+[Address1]) & (Chr(13)+Chr(10)+[Address2]) & (Chr(13)+Chr(10)+[Address3]) & (Chr(13)+Chr(10)+[Town]) & (Chr(13)+Chr(10)+[tblsurveyenquiry].[County]) & (Chr(13)+Chr(10)+[Postcode])
If anyone can help, it would be much appreciated.
Thanks
Richard