Lani
It's a bit tricky to do. Let's say your field with the option group ted to it is named Shift and it can have one of 2 values: 1, 2.
In a query for the report you would put this as the aliased field named ShiftDescription:
ShiftDescription: IIf([Shift]=1, 'Day', IIf([Shift]=2, 'Night', Null))
That way it would show up in the report as Day or Night. The IIf statement has 3 parts: the expression, the return if true and the return if false. In this case, you need to nest another IIf in the first to check for nulls unless you want to assume if it isn't 1 then it must be 2...but that is not advised.
--- In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Is it possible to change the value so on a report it doesn't read 1 or 2, instead it reads day or night for example? I tried going into the wizard and changing it when it gives you the numeric value but it won't let me. Has anyone done this before? Or is this just not possible?
Thanks,
Lani B.
Access Dummy
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar