Search results

Dear All, I have an access database with a price field. This contains a list of prices in the format $0.00. As this data has been imported it is contained within a text field. I have been rakking my brains trying to create a query to delete all the $ symbols from the prices, so that then...

Hello! I am trying to execute a query in Access but keep getting the following error message:confused: : "Data Type Mismatch in Criteria Expression" I have double-checked that the expressions are typed correctly and am certain that they are, here is the query SQL: SELECT [About...