Link to home
Start Free TrialLog in
Avatar of Ken
KenFlag for United States of America

asked on

QUERY EXPRESSION IN ACCESS GIVING WRONG FORMAT

I HAVE AN EXPRESSION THAT THAT IS A NUMBER BUT WHEN I EXPORT TO EXCEL THE FORMAT IS IGNORED.  IT APPEAR THERE IS A SPACE IN FRONT THAT NEEDS TO BE DELETED.  HOW CAN CHANGE THE QUERY EXPRESSION TO IGNORE THE SPACE.
Avatar of TheSloath
TheSloath

Use the Trim function, e.g. with field MyNumber from table MyTable:

SELECT Trim([MtNumber]) FROM MyTable
Avatar of Ken

ASKER

Didn't work
ASKER CERTIFIED SOLUTION
Avatar of TheSloath
TheSloath

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial