+ Reply to Thread
Results 1 to 3 of 3

Thread: =IF statements

  1. #1
    Registered User
    Join Date
    03-01-2007
    Posts
    36

    =IF statements

    Hello,
    I have a =IF AND( in Excel which works fine but when i use the same statement in access from the table that was exported to excel i get a run time error. Any ideas?

  2. #2
    Forum Moderator ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2003 & 2010
    Posts
    1,795

    Re: =IF statements

    Hi GeoGreco,

    Access doesn't use AND the same way Excel does.

    Cheers,
    Docendo discimus.

    Please consider:
    • Thanking those who helped you. Click the reputation icon in the contributor's post and add Reputation.
    • Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    03-01-2007
    Posts
    36

    Re: =IF statements

    Yes, that's what i just found out. AND is used After the criteria is entered, it works fine now. Thanks

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0