Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SIMPLE: Query feild question (Access2000)

    You guys, what is wrong with this statement? What i wanted it to do is, if the feild cancel is ticked then display "x" else nothing but it doesn't display anything even if cancel is ticked.
    Help me?
    CANCELLED: ([cancel]="True","x "," ")

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: SIMPLE: Query feild question (Access2000)

    Hi,
    Assuming [cancel] is a Yes/No field, try:
    CANCELLED: IIf([cancel],"X","")
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SIMPLE: Query feild question (Access2000)

    Oh, thank you Rory, you are an <img src=/S/angel.gif border=0 alt=angel width=15 height=21>
    <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •