Trim within makeup query

shaz123

Registered User.
Local time
Yesterday, 22:27
Joined
Sep 8, 2006
Messages
81
I have a makeup query, were i am tryin to trim one of the fields, how ever i keep getting this message,

Extra ) in query expresion 'TemplLines..[Trim([ARTNR])].'


However in the field i have typed this "ProductNumber: Trim([ARTNR])"
I cannot see were i am going wrong. I have included a print screen of my query any ideas.
 

Attachments

Do you have any VBA code anywhere? If so, do a search on this forum for References.
 

Users who are viewing this thread

Back
Top Bottom