report

mypig7

Active Member
Joined
Sep 27, 2004
Messages
285
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)
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,435
Messages
5,572,085
Members
412,441
Latest member
kelethymos
Top