We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

How do I recursively split a table into several smaller ones?

Jaysn
Jaysn asked
on
Medium Priority
248 Views
Last Modified: 2013-11-28
I'm trying to find a rapid way to split, export, and possibly email a list of records based on location & manager fields.  I have a table in Access 2007 with each record's location, manager, and supervisor listed, as well as other data.  What I would like to accomplish is to have this data split into sections for each supervisor that contains their data, a section for the manager that contains all of their supervisors' data, and a section that contains all data for an entire site, each of which would then be exported into a copy of a template Excel 2003 file for some graphs & such to be automatically created around the data.

Right now I manually sort & filter the data, then copy and paste it into the Excel template and send it off to the respective supervisor, manager, or site manager.  There are around 2000 records a week, from a handful of sites, each with managers and supervisors.  I would like to automate this task.  I have attached a basic table with my layout in case I'm not making very much sense.
Database1.mdb
Comment
Watch Question

Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
You can create Queries that you can use to Export to Excel. In your query, you would filter the data as need be (for example, you'd filter for Supervisor, the Manager, etc). You'd then use DoCmd.TransferSpreadsheet to do move the data to Excel (see help for more info on this topic).

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Is there any way to do this without creating an individual query for each file?  I'd rather not have to perform the maintenance needed for that method.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.