I want to create an interactive report on the web that would be served from my access database.
I would like to let user select criterias for the report on the web(dropdown lists or such) and then using queries to gather data from the access database and display it to the user.
Is there any softwear I can use ? Or shall I harcode(recreate the form with all dropdowns I would like to use) in html and connect the html report page to the database.
If so any rough instructions what comes after what .
I am using MS Access 2007. I have no idea how doI go about it?
Thanks for help in advance