Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-21-2019, 10:31 AM   #1
HangoutGuy
Newly Registered User
 
Join Date: Aug 2019
Posts: 28
Thanks: 18
Thanked 0 Times in 0 Posts
HangoutGuy is on a distinguished road
Building one same format for a report from different queries

Hi all,

I have 4 different queries that I want to build 4 separate reports of, one for each. Each query has all the same fields save for different locations, hence why I need 4 reports to send to the 4 locations.

I have spent a long time getting all the spacing and lining up to what I want and I have one complete report for one of my queries. I was wondering if there was a way to save the report I made as a template and then simply run the report template for the other 3 queries that I have.

Any guidance would be helpful, but if I just have to build 4 different reports it won't be the end of the world.

Thanks!

HangoutGuy is offline   Reply With Quote
Old 08-21-2019, 10:47 AM   #2
Gasman
Enthusiastic Amateur
 
Gasman's Avatar
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 4,814
Thanks: 457
Thanked 908 Times in 872 Posts
Gasman is a jewel in the rough Gasman is a jewel in the rough Gasman is a jewel in the rough
Re: Building one same format for a report from different queries

Would it not be easier having one report and filter for location on opening the report.?
__________________
Access novice. Sometimes trying to give something back.
Access 2007

Please, please use code tag # when posting code snippets

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.
Gasman is offline   Reply With Quote
The Following User Says Thank You to Gasman For This Useful Post:
HangoutGuy (08-22-2019)
Old 08-21-2019, 11:23 AM   #3
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,541
Thanks: 598
Thanked 1,008 Times in 950 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Building one same format for a report from different queries

I answered a similar question recently. "Generate Multiple Reports" There are 4 videos by way of explanation. I also provide a sample database you can download called "File - Generate Multiple Reports - Nifty Access" --- it's available to Access World Forum members for free, use the Coupon Code:- BuyMeA_Coffee! when you place your order. There are also links to some excellent blogs by MS Access Pro's demonstrating how to email the PDF documents.

Gina Whipp, a regular on This Forum:- Send eMail to Multiple Recipients...

Granite:- Emailing a different report to each recipient

__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|  
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)

Last edited by Uncle Gizmo; 08-21-2019 at 11:27 AM. Reason: Added Links
Uncle Gizmo is offline   Reply With Quote
The Following User Says Thank You to Uncle Gizmo For This Useful Post:
HangoutGuy (08-22-2019)
Old 08-21-2019, 11:37 AM   #4
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,399
Thanks: 108
Thanked 2,060 Times in 2,003 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Building one same format for a report from different queries

You may also get some insight from examples by Martin Green re Dynamic Reports.
You wouldn't build 4, build a template and accept some sort of Location filter/parameter as mentioned.
__________________

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.
jdraw is online now   Reply With Quote
The Following User Says Thank You to jdraw For This Useful Post:
HangoutGuy (08-22-2019)
Old 08-21-2019, 03:24 PM   #5
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,398
Thanks: 15
Thanked 1,624 Times in 1,542 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Building one same format for a report from different queries

Are the queries really different or do they just select different departments? If they just select different departments, add a combo to the report to select a department. If the combo's rowsource also includes the email address you need to send the report to, that would make it easier for you.

OR

If you want to send a report to every department, then you don't need to select them one at a time although leaving that as an option gives you flexibility. Your code can check the combo and if there is a department selected, send one report to that department. If the combo is empty, use a VBA loop that reads the department table and send the filtered report for each department.

To make the report include data for only a single department, an easy method is to use the WHERE argument of the DoCmd.OpenReport method.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
HangoutGuy (08-22-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Building Queries On the Fly from Martin Greene BDW Jr Modules & VBA 5 01-27-2015 12:55 PM
Dynamic Queries - building from forms? pat_nospam Forms 10 01-09-2004 01:35 PM
Need help building queries bacardi451 Queries 2 04-11-2003 06:38 AM
Building an expression control on a form created through queries Divinite Forms 8 02-27-2003 02:40 PM
Building Queries in Code TJBernard Forms 3 10-23-2002 03:15 AM




All times are GMT -8. The time now is 04:34 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 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World