I have a query as the source of a search program.
I want all the different phone numbers to be stripped of their spaces.
I have put in the query ClientPhone: Replace(([Clients]![Phone])," ","")
When I run it I get a "Date Type mismatch in criteria expression" error
The phone number is a short text field.
Any help would be appreciated
Regards
I want all the different phone numbers to be stripped of their spaces.
I have put in the query ClientPhone: Replace(([Clients]![Phone])," ","")
When I run it I get a "Date Type mismatch in criteria expression" error
The phone number is a short text field.
Any help would be appreciated
Regards