A
Anthony2004
Guest
Can anyone help me with this error?
Function is not available in expressions in query expression
'IIf([Agents].[IsAgency]=1,[Agents].[AgencyName],IIf(IsNull([Agents].[FirstAndMiddleName]),[Agents].[LastName],Trim([Agents].[LastName])&","&[Agents].FirstAndMiddleName]))'
A company wrote us an Access database but everytime we try and run the a report we get the above message. They say that it works just fine on their end but we can't seem to get past it. It was originally written in Access 2000 but has been recompiled in 2003. Is the syntax incorrect for 2003? Any assistance would be greatly appreciated.
Thanks
Anthony
Function is not available in expressions in query expression
'IIf([Agents].[IsAgency]=1,[Agents].[AgencyName],IIf(IsNull([Agents].[FirstAndMiddleName]),[Agents].[LastName],Trim([Agents].[LastName])&","&[Agents].FirstAndMiddleName]))'
A company wrote us an Access database but everytime we try and run the a report we get the above message. They say that it works just fine on their end but we can't seem to get past it. It was originally written in Access 2000 but has been recompiled in 2003. Is the syntax incorrect for 2003? Any assistance would be greatly appreciated.
Thanks
Anthony
