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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mpls - 23 Aug 2005 22:35 GMT

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?

Reply to this Message

Ofer - 23 Aug 2005 22:53 GMT

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")

> or 0,1,2 as never, past, present?
>
[quoted text clipped - 5 lines]
> 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?

Reply to this Message

Brian - 24 Aug 2005 01:51 GMT

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.

Reply to this Message