How to present 0,1 as yes/no in reports

[Guest]

or 0,1,2 as never, past, present?

I have data that are entered as 0 and 1 (imported from Excel), for reports
it would be easier to understand if they showed up as yes/no rather than 0,1.
Is there a way to do that (or is the easiest way creating a new column in
the respective data table that converts 0 to no and 1 to yes)?

I'm sure it is explained somewhere in the help section, but I don't know the
right nomenclature to find it. What should I be looking for?

 

[Guest]

In the ControlSource Property of the field you can write

=iif(FieldName]=1,"never",IIf([FieldName]=2,"past","present"))
Assuming that there are no other values beside 0,1,2

=IIf([FieldName]=0,"No","Yes")

 

[Guest]

If you need more options, you can set up a little conversion table:

ID Timing
0 never
1 past
2 present

Then, add this table to the query underlying the report, join on the ID
above, and add Timing to the report.

Alternatively, do this in the import process: import the data to a temporary
table, then append it to the live table but use the conversion table to
replace the simplistic entry with the verbose one from your conversion table.