Search results
-
P
Query remove spaces
Hi I'm great at Excel but a newbie to ACCESS 2013. Can anyone tell me how to remove all spaces from text (Postcode). I have tried a replace function but any postcodes without spaces show as an #Error I would like it as a query not VBA. Thanks for your help