locked
If Data Exist RRS feed

  • Question

  • User-1031608939 posted

    Hi,

    For MS Access, how to check if the particular field data exist?

    Thanks.

    Regards,

    ling

    Friday, March 18, 2011 5:26 AM

Answers

  • User-1199946673 posted

    I'm not sure exactly waht you mean? But waht about:

    (SELECT COUNT(*) FROM [tablename] WHERE .....) > 0

    This will return True if the data exist and false if no records are found...

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, March 18, 2011 8:45 AM

All replies