Posted - 10/15/2012 : 08:54:28
I have a query with the following fields. (SQL view from Mircosoft Access)
SELECT tblGIUSA.Company, tblGIUSA.FirstName, tblGIUSA.Surname, tblGIUSA.EducationalLevel
What will the SQL code be if I would like to change e.g:
- The values in Field Company to 25 = "North America", 50 = "South America"
- The text in field EducationLevel to "Bachelor degree" = "low education" and "Master degree" = "High education"
Thanks for all help.