Hi experts. We have an Access database that we're looking to improve. One option is to take it out of Access and convert to a web based format. Option 2 is to keep the platform we have for now and look at improving aspects of the tool. One improvement that needs to be made is to improve the user reporting. Anyone know of an existing module/code for allowing users to:
Select table they want to retrieve data from with corresponding fields.
Select multiple tables in one report
Dump one report with all selections to excel
Attached is a screen shot of what we currently have. Isn't nearly as robust as what we're looking to do.
Look forward to any recommendations! Thank you