User Profile

Collapse

Profile Sidebar

Collapse
DyingIsis
DyingIsis
Last Activity: Aug 8 '07, 08:46 PM
Joined: Aug 7 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • DyingIsis
    replied to Conditional Function Within Access Help
    in Access
    Hello -

    Super thanks for the quick response.

    I know that in Excel I need to put in a reference cell, how do I do that in Access?

    I want it to look within a certain field within a certain table and if it sees something that contains "v", then return "OK, if not then return "Not OK".

    Thanks again.
    See more | Go to post

      Leave a comment:

    • DyingIsis
      started a topic Conditional Function Within Access Help
      in Access

      Conditional Function Within Access Help

      Hello -

      I'm a relatively new user of Access.

      None the less, I have a function within Excel that I would like to recreate in Access.

      The function called (Check if part of a cell matches specific text) in Excel is below:
      =IF(ISNUMBER(SE ARCH("v",A2))," OK", "Not OK")

      I have been trying to replicate it in Access with little luck.

      Any help would...
      See more | Go to post
      No activity results to display
      Show More
      Working...