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

    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.

    David

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

  3. #3
    Join Date
    Jul 2004
    Posts
    34
    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
  •