Recent content by tension22

Hi, I need a query that works exactly like find and replace function. I have tried many ways, but the result is always the same - the whole string gets changed, not just the character/s in need. So if I need all "!" exclamation remarks changing to a "?" question mark it will do it. So would...

Hi, Would anyone know to create a delete query that looks up the criteria to delete from another table of products. So the result would be, to delete all records were items in PRODUCT collum matches products in the other table, so on completion every record the contains a product in the...

Hi, Basically I have around 200 UPDATES that need to run, so from collum 'products' I need to change: PC to DELL PC Ipod to Apple Ipod x another 200 updates. Obviously that will take ages to run each one on there own. So I have tried to make another table to hold the original value, and the...