Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2014
    Posts
    1

    Unanswered: Adding a Y or N to a field if it's Not null in Access 2010

    I have an field called USOFLAG and i have another field called USLINE and if that filed is not null i want it to say Y ELSE N in the USOFlag Field and the same for CAOFlag and CALINE6 is not null then Y Else N for that field. I have an image to show you what i'm talking about. Please help!!!!.
    Attached Thumbnails Attached Thumbnails access form.png  

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Code:
      if not isnull(USLINE) then
         USOFLAG = "Y"
      else
         USOFLAG = "N"
      endif
    
    
    
      if not isnull(CALINE6) then
         CAOFlag = "Y"
      else
         CAOFlag = "N"
      endif

Posting Permissions

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