Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: Counting records in a query

    I know this should be easy, but searching did not fine the answer I needed, so I apologize.

    I just need a simple statement that will count the rows in a query for an IF THEN statement. Basically, if an update is made, then I need an email sent, else don't send an email. The query returns rows for updates that haven't been addressed yet. If the query does not bring anything up, then no email is sent. This way if someone posts several updates, I don't get an email for every update, just one for the all the changes made (this is just an email to let me know updates were made, not specific data). The email part is fine, I just need the count. Thank you for any help.


  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    Something like :
    IF NZ(DLOOKUP("[MyCol]", "MyTable", "MyCol = 12345"), -1) <> -1 THEN your thing...
    END IF
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2004
    Yes! That did it exactly. I knew it had to be simple. Thank you so much.

Posting Permissions

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