I am presently building a database in Ms Access 2007. The user have indicated that they would like to select their own fields when generating a report. It is possible that the fields can be randomly chosen. I would prefer that the user can simply click check boxes representing each field and click on a command button which opens onto the report.
Can anyone suggest a solution to this problem.