+ Reply to Thread
Results 1 to 8 of 8

Access Report Template

  1. #1
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Columbus Ohio
    MS-Off Ver
    Excel 2010
    Posts
    137

    Access Report Template

    I am creating a report in access. The same report design will be used for 24 different queries. Is there a way to save a template so I can load it and just change the source or is there a away to do a drill down report where the user selects the query from a drop down? The query is an unmatched query and only contains 1 column. Any advice or suggestions would be great.
    Last edited by jonboy6257; 11-21-2013 at 09:50 AM. Reason: Solved

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,492

    Re: Access Report Template

    Are the 24 queries basically the same query with 24 different criteria?

  3. #3
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Columbus Ohio
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: Access Report Template

    Yes. There are 48 tables. One table is in stock in a certain section and the other is the master list for a certain section. Each query is an unmatched query to determine which bins have no stock. There are 24 different sections a1-a6 b1-b6 c1-c6 d1-d6. So it was a big hassle getting the information together in the first place.

  4. #4
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Columbus Ohio
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: Access Report Template

    I don't mind doing it 24 times but I would rather save a template.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,492

    Re: Access Report Template

    Look at this link. It may give you an idea on how to deal directly with your issue. Instead of 24 queries. One with a parameter.

    http://www.datapigtechnologies.com/f...mtoreport.html

  6. #6
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Columbus Ohio
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: Access Report Template

    Thank you alansidman. I will watch it when I get home. I share an office and don't want to bother the other person with the sound. I'm thinking, just from the little I watched with no sound, that it should be sufficient. My issue is I figure out how to do something but it isn't efficient. Like with the 24 different queries. I won't marked solved yet just in case it doesn't work once I get home.
    Thanks again!

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,492

    Re: Access Report Template

    FYI--when I work in an office and need to see a video, I plug in my iPhone earbuds. Think about leaving a set in your office.

  8. #8
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Columbus Ohio
    MS-Off Ver
    Excel 2010
    Posts
    137

    Re: Access Report Template

    Sound advice sir, thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Report Specification Template
    By JungleJme in forum Excel General
    Replies: 0
    Last Post: 08-01-2012, 07:12 AM
  2. Expense Report Template?
    By zekepictures in forum Excel General
    Replies: 5
    Last Post: 06-22-2011, 07:01 AM
  3. Localize Access Report and Excel Template
    By Peter in forum Excel General
    Replies: 0
    Last Post: 03-29-2006, 03:20 AM
  4. Expense report template
    By tired of searching in forum Excel General
    Replies: 2
    Last Post: 05-22-2005, 03:06 PM
  5. Cash report template
    By vishu in forum Excel General
    Replies: 0
    Last Post: 02-24-2005, 01:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1