Solved Training Matrix (1 Viewer)

Krayna

Member
Local time
Today, 22:26
Joined
Sep 24, 2020
Messages
514
I'm struggling with creating a query to summarise the data in the format specified by the client.
They would like a table such as below:
Staff IDTraining Category & Title of Training - all statutory trainings as columns
1Date of most recent training
2or "No" if null
3...

The data is in a database.
All staff are to appear once in the left-hand column and all statutory training (if date not expired) are to appear as the columns. Note several trainings may be recorded for each category so only the latest date should be displayed.

What's the best way to create this?
 

Attachments

  • trainingMatrixTEST.accdb
    512 KB · Views: 40

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 22:26
Joined
Jul 9, 2003
Messages
13,553
I have an example of Stephen covey's time management matrix done in MS Access on my website here:-


The main purpose of the example is to demonstrate how you can use a carrier form (main form) which holds the four subform/subreport controls and then use one single form in each subform/subreport control, (one single form utilised four times)
demonstrating how you can use a single form multiple times...
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:26
Joined
May 7, 2009
Messages
14,607
see query4.
note: no record on staff table so cannot join it in query.
 

Attachments

  • trainingMatrixTEST.accdb
    664 KB · Views: 72

mike60smart

Registered User.
Local time
Today, 22:26
Joined
Aug 6, 2017
Messages
1,000
I'm struggling with creating a query to summarise the data in the format specified by the client.
They would like a table such as below:
Staff IDTraining Category & Title of Training - all statutory trainings as columns
1Date of most recent training
2or "No" if null
3...

The data is in a database.
All staff are to appear once in the left-hand column and all statutory training (if date not expired) are to appear as the columns. Note several trainings may be recorded for each category so only the latest date should be displayed.

What's the best way to create this?
The following Report View is one way of displaying the data.
 

Attachments

  • StaffTraining.JPG
    StaffTraining.JPG
    100.3 KB · Views: 189

Krayna

Member
Local time
Today, 22:26
Joined
Sep 24, 2020
Messages
514
@arnelgp - Thanks for that sample. I have now filled in the tblStaff with fictitious names.
Also I only want one column for each category (to decrease number of empty spaces in final result) so each category be joined together - I have added some more info to the training table to assist.

@mike60smart - I like the report view. Although it includes a lot of detail, so maybe I can offer 'display more detail' to show this option. Can you explain in more detail how this was achieved?
 

Attachments

  • trainingMatrixTEST.accdb
    688 KB · Views: 184

mike60smart

Registered User.
Local time
Today, 22:26
Joined
Aug 6, 2017
Messages
1,000
Hi

It is just a report based on query1

See the attached.
 

Attachments

  • trainingMatrixTEST.zip
    42.7 KB · Views: 186

Users who are viewing this thread

Top Bottom