How to Display the value as Yes/No not -1/0

[anon1971]

Here is the statement I am stomped pn how to get the NotesD.Complete to show the results as yes and no rather than -1 and 0. Any help

SELECT DISTINCTROW NotesD.User, NotesD.Subject, NotesD.NoteDate, NotesD.FollowUp, NotesD.Complete, NotesD.NoteID
FROM NotesD WHERE (((NotesD.ProjectID)=[forms]![sProjects]![ProjectID]))
ORDER BY NotesD.NoteDate DESC;

 

[SkipVought]

Hi,

, IIF(NotesD.Complete=0,"NO,"YES")

Skip,
[sub]
[glasses]Just traded in my old subtlety...
[b]for a NUANCE![/b][tongue][/sub]

 

[dhookom]

If the results are displayed in a form or report, you should just set the format property in the text box. Messing around with the values in the query sometimes limit the functionality later.

Duane
Hook'D on Access
MS Access MVP

 

[anon1971]

Don't want to change the value just change how it is displayed in the unbound box. Skip that code gives and error.

 

[SkipVought]

Sorry, missed a QUOTE

IIF(NotesD.Complete=0,"NO","YES")

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[anon1971]

Thanks skip here is the finished product for future needs:

SELECT DISTINCTROW NotesD.User, NotesD.Subject, NotesD.NoteDate, NotesD.FollowUp, IIF(NotesD.Complete=0,"NO","YES") As Complete, NotesD.NoteID
FROM NotesD WHERE (((NotesD.ProjectID)=[forms]![sProjects]![ProjectID]))
ORDER BY NotesD.NoteDate DESC;