report

[mypig7]

I have a database showing details of who has attended a training course.

I want to have a report which shows who has been trained, where they work and the "period" that they were trained in.

How do I get a box to appear which asks:-
Between which 2 dates do you wish to see data from?
Or
Which Department do you want
Or
Which Course do you wish to view.

Any of these options would help.

And then the report will be based on my reply.
(I am fine creating a basic report)

 

[Andrew Fergus]

Hi

You need to base the report on a query and introduce a the criteria you described into that query. Have a read of this webpage from Martin Green - it helps with the syntax when users want to ignore your prompt for information. When the report is opened, the query intervenes and the message boxes automatically pop up asking for the information. You will need to think about whether these are 'And' criteria (i.e. all must be satisified) or 'Or' criteria (only some need to be satisified, if any) and place the criteria accordingly on either the same row or differing rows within the query.

HTH, Andrew

 

[mypig7]

thanks