Choosing most but not all records in a field to report.

[Guest]

Hello

I have a number of 'courses' in my database & a form allowing you to attach
any number of 'modules' to each course. I then have a report that presents
these 'courses' with their 'modules'.

The problem is I also need an additional report that shows these 'courses'
with most but not all of their 'modules'. Further, this cut-down list of
'modules' will not always be the same.

Is there any way I can present the 'courses' with the 'modules' that were
chosen previously that then allows the user to remove some of the modules &
produce a report showing these 'courses' with the cut-down list of 'modules'?

Basically, the only way I can think of achieving this is to have another
form where the user has to go through the process of attaching 'modules' to
'courses' again (but in this case would choose most but not all modules).
Thus, almost duplicating the original process which seems inefficient.

I apologise for the long-winded explanation but I just wanted to be clear (I
hope it is)!

 

[Ed Warren]

How one would do this depends on if you need to rerun the reports or just do
it once for each user etc.

Easy answer is to build a temp table of courses/modules with a new field
Selected (yes/no). Set all to not selected, tie to a form and allow the
user to check the ones they want and print a report.

Ed Warren

 

[Guest]

The report would only need to run once so that is the perfect solution, thank
you.
I think I was over-complicating the matter when trying to find a solution!
Heidi