I would like to create a make table query in access. Before populating the results in the table, I want to change values in the results for one of the columns using "IF" statements.
e.g. If value = "XXX" then
change value to "YYY"
Should I put the If statements in the SQL statement?
How do I change the values?
Thanks for your help.
SELECT X, Y, Z
FROM [tbl1] INNER JOIN [tbl2] ON [tbl1].[Customer Account Number] = [tbl2].AccountNumber
WHERE ((([tbl1].[Customer Account Create Date]) Between "20110901" And "20111001"));