I'm sure this is easy and I'm just overlooking something but I'm trying the use an update query with a replace statement to remove part of the data in a field but am having no luck...
I have a column with this type of data:
Column Name = test
After running the query I'd like to data to just be:
In the update to field I have Replace([test],".*","") - thinking this would remove anything after the dot in the data but it doesn't seem to work...
Thanks for any pointers you can offer in where I'm gonig wrong....