SELECT DISTINCTROW tbl1.Date, "Yes" AS Displ
FROM tbl1
WHERE (((tbl1.Choice)=-1));
This is a very basic sample that displays "Yes" where records are checked. Field "Date" is just a control, "Choice" the checkbox field and "Displ" as the function. This is a copy&paste of a qry in SQL view, in Design view it's no more than pulling "Date" and "Choice" into the grid, criteria for choice set to -1 & Show unchecked, plus
Displ:"Yes".
Certainly more of an inspiration than a solution, at least
I don't know if you are still listening or not but the simplest thing to do is to put a text box on the form or report and make the control source your check box field. Then go into the format tab of the property sheet and on the format line click the drop down arrow and select Yes/No.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.