I am a PHP / MySQL developer that has been given the task of adding a view / email report within an classic ASP / Access application. Normally, I would write a simple query with an ORDER BY and a GROUP BY statement, but this does not seem to work with Access. So, I need expert help. Let me define the problem:
Assume an Access Database Table named CRM with the following fields: ID, type, employee, message.
Assume that there are five distinct type values: email, phone, meeting, voicemail, other.
(There is an image attached of the database structure for reference.)
I am trying to write a simple query that generates a report sorted by Employee and showing the count of each type for that employee today.
Here is an example of what I mean:
email = 3
phone = 5
voicemail = 6
email = 5
voicemail = 9
How can this query be written? You can assume that the current date can be brought into the query as a variable.
The output of the query needs to be viewed on a Web page using Classic ASP. If you can provide that code, that would be great as well. Assume I am using the following connection:
Set objRS = Server.CreateObject("ADODB