Hi Guys,
I used the Trim Function in to my Queries and its working fine since yesterday:
eg. FullName: Trim([m01LastName] & " " & [m01FirstName])

Now, when I tried to run that query I'm getting an error:
Function is not available in expressions in query expressions 'FullName: Trim([m01LastName] & " " & [m01FirstName])'.

I remember the last time I get this error is when I upgrade from Ac97 to Ac2000 which is 2 years back I guess.

I re-install already my Access2K, run the Detect and Repair and still same error. Any ideas why or how this happened?

Happy New Year to All of you!

TIA,
George

DISREGARD!!

I created one blank db and import all objects and now it's working. I guees my db get corrupted but compact and repair doesn't work.



> -----Original Message-----
> From: George Oro [mailto:george@c...]
> Sent: Tuesday, December 31, 2002 11:42 AM
> To: Access
> Subject: [access] Trim Function
>
>
> Hi Guys,
> I used the Trim Function in to my Queries and its working fine since yesterday:
> eg. FullName: Trim([m01LastName] & " " & [m01FirstName])
>
> Now, when I tried to run that query I'm getting an error:
> Function is not available in expressions in query expressions 'FullName: Trim([m01LastName] & " " & [m01FirstName])'.
>
> I remember the last time I get this error is when I upgrade from Ac97 to Ac2000 which is 2 years back I guess.
>
> I re-install already my Access2K, run the Detect and Repair and still same error. Any ideas why or how this happened?
>
> Happy New Year to All of you!
>
> TIA,
> George
>
>