Ken
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.
ASKER
Didn't work
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT Trim([MtNumber]) FROM MyTable