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)
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Andrew Fergus

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,449
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
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 :)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,802
Messages
5,833,751
Members
430,229
Latest member
TestableEmu263

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top