Hi,
I am new at MS Access and with hit and try I was able to create a report in access. The report has around 15 columns and around 1000 rows. The data in some of the columns is the same. What I mean is that, for example, column 1 is "Division" and has around 200 rows each of the 5 divisions namely HR, IT, Finance, Operation, Supply. Similarly I have some more columns with similar data. Also, the reports last column is attachments which has the attachments.
The report is generated after user selected the data from a form.
Could you please help me with the below question:
1. Is it possible that I can create a textbox or a list box in the report header to show the unique values for the divisions (for example only HR, IT if those were the only ones) generated in the report.
2. I want to download this report as a pdf and as an excel, how can I also download all the attachments with the report. Right now, if I download the report, the attachments are not included.
3. Is it possible to give the user permissions so that they can add attachments in the report itself while viewing it.
Thanks a lot for your help.