How to display yes/no box

[willy292]

the [EFS] and [CB] is one of the team for handling the project but after I execute the query as below , it just show -1, 0 as the picture but they are orginally
Yes/No box from the table, how can I display the result as a Yes/No box
instead of -1 ,0

--------------------------------------------------------------
SELECT Projects.[Project Name], Projects.[EFS],Projects.[CB]
FROM Projects
WHERE (((Projects.[EFS])=Yes) AND (([Forms]![A]![EFS])=Yes));
UNION SELECT Projects.[Project Name],Projects.[EFS], Projects.[CB]
FROM Projects
WHERE (((Projects.[CB])=Yes) AND (([Forms]![A]![CB])=Yes));

 

[CJ_London]

In a query, you can't without modifying the code - but normally you would display the results in a form in which case you woud use a checkbox

If you want to see Yes/No in a query then modify your code as follows:

[FONT=Calibri]SELECT Projects.[Project Name], iif(Projects.[EFS]=Yes,"Yes","No"),iif(Projects.[CB] =Yes,"Yes","No) FROM Projects WHERE (((Projects.[EFS])=Yes) AND (([Forms]![A]![EFS])=Yes)); [/FONT]