Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-19-2019, 07:07 AM   #1
Djblois
Newly Registered User
 
Join Date: Jan 2009
Posts: 578
Thanks: 0
Thanked 0 Times in 0 Posts
Djblois is on a distinguished road
Create This Report?

I have a table in Access with Employee Name, Position (selector, Loader, Reacher, etc) and Location (Cool, Dry, Freezer). I now need to create a report that mimics the picture I sent. I know how to do it with 12 subreports and 12 queries. Does anyone have any idea how I can reduce the number of subreports or queries?
Attached Images
File Type: jpg Image 4.jpg (86.3 KB, 17 views)

Djblois is offline   Reply With Quote
Old 07-19-2019, 07:17 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,563
Thanks: 38
Thanked 869 Times in 852 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Create This Report?

Hi. Maybe you really only need to create one subreport but use it twelve times on the main report.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 07-19-2019, 07:19 AM   #3
Djblois
Newly Registered User
 
Join Date: Jan 2009
Posts: 578
Thanks: 0
Thanked 0 Times in 0 Posts
Djblois is on a distinguished road
Re: Create This Report?

can you use the same subreport 12 times on one report? you cannot do that with the same subform multiple times on a form. Also how would I have each subreport query based on different criteria?

Djblois is offline   Reply With Quote
Old 07-19-2019, 07:23 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,563
Thanks: 38
Thanked 869 Times in 852 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Create This Report?

Quote:
Originally Posted by Djblois View Post
can you use the same subreport 12 times? you cannot do that with subforms? Also how would I have each subreport query based on different criteria?
Yes, you can, and you can also do the same with subforms. As an example, take a look at some Calendar demos, especially the ones that display appointments or events for each day of the calendar. You might see the same subform is used for each date on the calendar form.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 07-19-2019, 09:36 AM   #5
Djblois
Newly Registered User
 
Join Date: Jan 2009
Posts: 578
Thanks: 0
Thanked 0 Times in 0 Posts
Djblois is on a distinguished road
Re: Create This Report?

I just tried it. In the past I always assumed the subform showing up all white in design view meant it would not work. Well I just ran the form ant it works. However, how do I make it so they each have their own query?
Djblois is offline   Reply With Quote
Old 07-19-2019, 09:43 AM   #6
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,563
Thanks: 38
Thanked 869 Times in 852 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Create This Report?

Quote:
Originally Posted by Djblois View Post
I just tried it. In the past I always assumed the subform showing up all white in design view meant it would not work. Well I just ran the form ant it works. However, how do I make it so they each have their own query?
You could try using code to do that. If you found an Calendar example, you might see the author simply used the Linked Master/Child Fields to show different data in each subform.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Use VBA to CREATE a report modest Reports 24 03-15-2012 12:45 AM
How to create Outstanding report and Aged Debtors Report Sunnylei Reports 5 07-18-2011 03:27 PM
Create a query, to create a report, to send in email smalls530 Reports 5 03-20-2009 09:51 AM
Need to create a report- PLEASE HELP! ollechka Reports 0 05-23-2006 05:10 AM
create new report kmiller Reports 1 02-07-2001 01:54 PM




All times are GMT -8. The time now is 12:59 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World