Hi Drew,
Hmmm... I'm an A97 user, so maybe I'm missing something
re A2000.
I don't understand "ADP" - ? Maybe it's a "duh", but
spell it out, please.
Also, when you say [EmpDD] is a bit field, is that
unique to A2000, or do you mean it's a byte field that's
user-set to either 1 or 0 within an allowable range of 0-
256, or do you mean it's a Yes/No field? If the latter,
then True=-1, not 1, so maybe you need to test for [EmpDD]
=-1 for true cases.
Nothing beats a face-to-face with the beast on screen, but
let's keep going until the nut is cracked.
HJ
-----Original Message-----
Still didn't work... I am develping a ADP, is that any different?
Thanks,
Drew
Try this...
Assuming you mean a "DD/" prefix to the value, instead
of using the [EmpDD] field in the report, use a text box
containing: ="DD/"&[EmpDD].
If you want to display ONLY when EmpDD=1 and display
nothing when [EmpDD]=0, then in the text box say: =iif
([EmpDD=1,"DD/"&[EmpDD],"").
If you want to display in both cases but only prefix
the 1 case, then in the text box say: =iif([EmpDD] =1,"DD/"&
[EmpDD],[EmpDD]).
HTH
-----Original Message-----
I am working on a report using Access. I would like to
display DD/ if the
EmpDD field is 1 (it is a bit field, 1 or 0). How can I
accomplish this? I
am using Access XP (2002)
Thanks,
Drew
.
.