G
Guest
I'm having a problem using the Trim function in a query expression. I'm
running Access 2000 9.0.6926 SP3.
When I run the query on my computer, I don't have any issues. When I run
the query on another person's computer, I get the following error message:
Function is not available in expression in query expression
Trim([IMITMIDX]![ITEM_NO]). The field in the query looks like this: txtP/N:
Trim([IMITMIDX]![ITEM_NO]).
I've gone through and done the Office Updates for the computer that I'm
having issues with and it still does not solve the problem. Any ideas on
what I'm missing?
Thanks for the help,
John S.
running Access 2000 9.0.6926 SP3.
When I run the query on my computer, I don't have any issues. When I run
the query on another person's computer, I get the following error message:
Function is not available in expression in query expression
Trim([IMITMIDX]![ITEM_NO]). The field in the query looks like this: txtP/N:
Trim([IMITMIDX]![ITEM_NO]).
I've gone through and done the Office Updates for the computer that I'm
having issues with and it still does not solve the problem. Any ideas on
what I'm missing?
Thanks for the help,
John S.