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
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