I am using Access 2002 I am needing to create an update query that will find and replace in a field.
Table Name: All
Field Name: Date and Time
Find 1/1/1900 12:00:00 AM in the Date and Time field and replace with a blank ("").
I have tried multiple ways and can not seem to find a solution.