Query Question

[Daniel]

Hi Guys

Basically I have a query that I need a bit of help with. I need to have one
of the results in the the query to change what is returned for example

" Harry" would appear in the query as " Judy"

I must only have this changed in this one query

Here is how my sql looks right now

SELECT [Vacancy Details].School, [Vacancy Details].[Vacancy Classn],
[Vacancy Details].[Vacancy Details], [Vacancy Details].[Vacancy From],
[Vacancy Details].[Vacancy To], [Vacancy Details].[Vacancy Reason], [Vacancy
Details].[Reason Vacacny not Filled], [Vacancy Details].[Vacancy Type],
[Vacancy Details].[Position #], [Vacancy Details].[Vacancy To], [Vacancy
Details].[Position #], [Vacancy Details].[Action Officer]
FROM [Vacancy Details]
WHERE ((([Vacancy Details].[Vacancy From])<=[date]) AND (([Vacancy
Details].[Face to Face])="Face to Face Classroom") AND (([Vacancy
Details].[Vacancy Action])="Position Not Filled"));

 

[akphidelt]

I'm not sure which one is where Harry shows up... but assume that Harry shows
up in the [Vacancy Details].[Action Officer]

You can write this at the end of the SELECT in the SQL Code

IIF([Vacancy Details].[Action Officer]="Harry","Judy",[Vacancy
Details].[Action Officer]) As [Action Officer Revision]

If it isn't action officer change it to whatever it is that has Harry in it.

Not sure if this helps, but it would work