Re: EXPRESSIONS
- From: "MDI Anne" <MDIAnne@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 26 Aug 2005 11:48:13 -0700
Fredg,
As in my previous post, this works excellent! My next question is, how can
I ONLY return those lines with an "R" or Null value?
Again, Thank you for any help.
As you can probably tell, I'm pretty new to Access...and am anxious to learn
as much as I can.
"fredg" wrote:
> On Fri, 26 Aug 2005 10:45:01 -0700, MDI Anne wrote:
>
> > In my query I get several values for my EVENT_CODE field. I am only looking
> > to find the "R" code and the null codes. For the "R" codes I would like to
> > show a "Y" for yes, and for the null codes I would like to show a "N" for no.
> > Right now I have this in 2 different columns, but would if possible, like to
> > have this in 1 column.
> >
> > Am I remotely close with my expressions? and How do I do this in 1 column?
> >
> > Expr1: IIf([EVENT_CODE]="R","Y")
> > Expr2: IIf(Len([EVENT_CODE] & "")=0,"N")
> >
> > Thanks for any help!
>
> Exp:IIf(IsNull([Event_code]),"N",IIf([Event_Code]="R","Y",""))
>
> --
> Fred
> Please only reply to this newsgroup.
> I do not reply to personal email.
>
.
- Follow-Ups:
- Re: EXPRESSIONS
- From: fredg
- Re: EXPRESSIONS
- References:
- EXPRESSIONS
- From: MDI Anne
- Re: EXPRESSIONS
- From: fredg
- EXPRESSIONS
- Prev by Date: Re: "You canceled the previous operation."
- Next by Date: Using a time frame, now asks for it even for design view
- Previous by thread: Re: EXPRESSIONS
- Next by thread: Re: EXPRESSIONS
- Index(es):
Relevant Pages
|
