Changing strings in a query
Posted on 2003-11-25
I'm not sure if this is doable in ACCESS and my VB is weak.
I'd like to be able to change a string that's in a query. For example;
SELECT rank4.'AQ4_10' AS Response, rank4.[FACING NAME], Nz(Count([rank4].['AQ4_10]'),0) AS Expr1, Count(rank4.AQ4_10) AS [All Depots], "AQ4_10" AS question
GROUP BY rank4.'AQ4_10', rank4.[FACING NAME];
I'd like to have a form, or some user friendly method to change the 'AQ4_10' everywhere it appears and then run the query again.
Where do I start, can I do it?
I'm showing the query in SQL...I actually put it together in a Design View