Good morning everybody,
I have written the following expression in a query, asking the question if the difference between a date and today is 12 months or less:
12_month_limit: IIf(DateDiff("m",[Most recent audit date],Now())<=12,True,False)
The formula works and outputs either 0 or -1.
However, I would like the output to appear as a checkbox in the query, rather than 0 & -1. When looking at the property sheet section Lookup --> Display Control, currently "Text Box" is selected. The other options are "List Box" and "Combo Box". Unfortunately, check-box does not appear.
Does anyone know how to change the output to check boxes, rather than 0 &-1?
Thank you for your help!!