CODEWITHSUNDEEP
ms-access
AccessBeginner
AccessBeginner

Reputation: 15

Replace Data Query

I created a fairly simply Access database. I am going to be using this with an inventory database. Boxes all have numbers that will include an asterix before and after each number. For example, 101 will read 101 in order for the scanner to read it. Is there a way to write a query that will delete every asterix in all of the records?

Thanks in advance for your help!

Upvotes: 1

Views: 922

Answers (1)

Don Jewett
Don Jewett

Reputation: 1967

An Update Query using the VBA Replace Function should work fine

UPDATE [TableName] SET [FieldName] = Replace([FieldName],"*","")

References

Upvotes: 1

Related Questions