Ad-Hoc Report.mdb

Credit goes to: I modified it, but I don't remember where I got it originally, if you know please let me know.

When open the frmQAMain, detail of Question and Answer shows and you can add data from this form also. From this frmQAMain form, click Report button to open ad-hoc report form.

In Report form, there are 4 buttons - Show List, Clear, Report and Exit:

1. Show List button - when click it without enter the selection, shows all existing data. Enter the paticular data into any one of the text boxes, then click this button will show only selected data - Ad-hoc report. (If you don't know what data in it, just click Show List button to see all data.) For example; type Andy Anderson into Closed By text box, then click Show List button, will show you only that particular data and if you want click report button and print it out from that.
2. Clear button - clear up all showing data.
3. Report button - will open report that match to you selected data.
4. Exit button - close the application.

Download Access 2000: uploads/23/Ad-hocReport.zip