Seems easy, but Im not quite gettng it. I have a form that has a button on it. I want anyone who clicks on the button to be able to enter a year and month that queries the total number of records in the table during that time frame. Then I would like a message box to popup and say "There were X amount of records entered this month." I do not want the resulting query table to be displayed, just a message box.
My sql query is:
SELECT Count(RecordList.TrackingNumber) AS CountOfTrackingNumber
FROM RecordList
GROUP BY Year([EntryDate]), Month([EntryDate])
HAVING (((Year([EntryDate]))=[Enter Year]) AND ((Month([EntryDate]))=[Enter the Month #]))
So now how can I run this query off of clicking a button and then display my count in a message box?