How do I get a query based report on our intranet, without each person having to open the entire database or having access to the database? The report is set up to search 2 fields in the database that asks for a specific dept.# and the start and enddate then the report returns the results based on the user’s input. The # of users for this report will be over 100. The ideal outcome is to select the option to search, enter your info. and just receive the results in the report format without having to have the DB open on their computer and/or even have Access on their computer. We are not running SQL server.
