How do I report column names in a query in Access?

[Russ]

I need to print a column name instead of the data if a field contains a
specific value.

 

[Alex White MCDBA MCSE]

Hi Russ,

SELECT Candidate.CANDIDATE_ID, Candidate.TITLE,
IIf([First_Name]="Alex","First_Name",[First_Name]) AS My_First_Name,
Candidate.FIRST_NAME
FROM Candidate

Does that do want you want.....

 

[russ]

Hi Russ,

SELECT Candidate.CANDIDATE_ID, Candidate.TITLE,
IIf([First_Name]="Alex","First_Name",[First_Name]) AS My_First_Name,
Candidate.FIRST_NAME
FROM Candidate

Does that do want you want.....

--
Regards

Alex White MCDBA MCSE
http://www.intralan.co.uk

I need to print a column name instead of the data if a field contains a
specific value.

Thanks. Looks like it'll work for what we want.