Hi,
I am redeveloping our support database built on Access with a front end back end DB. I would like to count the records in the job info table but struggling to get the code to be able to do this.
I have tried different attacks but come back with the same results.
Jobs are logged by auto number record my code would like to show the following for example:
Total Tickets Logged = 3456 Assigned Tickets = 20 Total Tickets Today = 12
I know each area will give me different issues I am connecting to my MDB using PDO connection.
Any help would be appreciated thanks in advance.
Thanks PHPJames