different subreports depending on the day, using a master report

[scopes456]

I have a database for daily activities, in the database Master_tbl keeps track of which forms I filled out for the day. I have separate reports for each table, I would like when I select a given day it will only pull the reports for that day. For example one day I might fill out Clean-up log and employee detail, and another day I might only fill out one report. I know using subreport I can pull all the reports in one, but I want just the reports that was filled out for that day.

Master_tbl keeps track of all other tables using Master_ID.

 

[sneuberg]

I have a database for daily activities, in the database Master_tbl keeps track of which forms I filled out for the day.

How does it do that? And do you mean Access forms?

I have separate reports for each table, I would like when I select a given day it will only pull the reports for that day.

What you mean by day? Day of the week or specific dates? What information exists in the table that would allow you do this?

For example one day I might fill out Clean-up log and employee detail, and another day I might only fill out one report. I know using subreport I can pull all the reports in one, but I want just the reports that was filled out for that day .

I'm confused. How do you fill out a report in Access?

 

[scopes456]

sneuberg, I have a form that i enter daily activities, i call it Master_Frm. The form has Date, Activitie 1, activitie 2, activite 3. From there i can select different activities, when i do my subform loads to fill out the information. When you look at Master_tbl:

Master_Id Date Activitie 1 Activitie 2 Activitie 3
1 11/18/2015 clean up restock order supplies
2 11/16/2015 clean up

Clean up , restock , order supplies - all have there reports. Using Master_ID i can put all these reports as sub reports and when i select a date it will load the report.

I would like, instead of it pull all 3 reports that it only pull the activites that was filled out on that date. For example on 11/16/2015 - when i select that date it just pulls the "clean up "sub report .

hope this clears things up

 

[sneuberg]

I'm still not getting it. Could you upload your database or strip down version that has this part.