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.