In a query, I generate an expression that may result in either true or false.
It is a simple IIf where I check if there is more than one transport, like this:
IIf([NUMBER_OF_TRANSPORTS]=1;True;False)
The result coms out as either 0 or -1.
I would, for the sake of the human eyes looking at it, like for the result to be displayed with a checkmark instead.
I've tried to use a calculated field in the table instead. This can be done, but this makes it harder to reprocess the data at later steps. So I would like to do the calculation via an expression in a query.