Results 1 to 4 of 4
  1. #1
    eskojuippi is offline Novice
    Windows 8 Access 2013
    Join Date
    Mar 2015
    Posts
    2

    Can i use one report template to all

    Hi all! I have few beginner questions i don't find answers to.


    Can i use one report template to all my queries?
    How do i import my new query data to my report template?
    If i make changes to query, how can i refresh the data to report?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,645
    What do you mean by 'all my queries'? Are these queries all the same data and just applying different filter criteria?

    What changes? Just filter criteria?

    Review http://www.datapigtechnologies.com/f...mtoreport.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    eskojuippi is offline Novice
    Windows 8 Access 2013
    Join Date
    Mar 2015
    Posts
    2
    Quote Originally Posted by June7 View Post
    What do you mean by 'all my queries'? Are these queries all the same data and just applying different filter criteria?

    What changes? Just filter criteria?

    Review http://www.datapigtechnologies.com/f...mtoreport.html
    Yes, all the queries i want to make is from the same data, using different filter criteria.

    Can i create new queries, then import that to my old report template, if the filters are the same on both formulas?
    How do i exactly do this? Create query, then save it, then open my report template and it opens report with query data i made?
    Or do i have to open the query first, then open my report template?

    I can't test this since i'm on holidays and can't "access" my working computer.
    I assume i could just edit the query i have, but i want to keep list on what i have done, so i need them saved separate for later use.

    Thanks for replying, i really appreciate it.
    -Esko

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,645
    Did you review the tutorial in the link? It is one way to open report with different filter criteria.

    I am not sure what you mean by 'import to old report template'. What do you mean by 'keep list'?

    A query does not have to be 'opened' for data to display on report. A report has a RecordSource that uses a table or query. Just open the report.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 11-05-2014, 05:35 PM
  2. How to create a report template
    By Johanb26 in forum Reports
    Replies: 8
    Last Post: 06-30-2013, 04:18 PM
  3. Import Excel file as report template - possible?
    By justinwright in forum Reports
    Replies: 2
    Last Post: 11-01-2010, 07:01 AM
  4. Report template requirement
    By pieniaszek in forum Reports
    Replies: 0
    Last Post: 07-29-2009, 07:25 PM
  5. I need help with this Template
    By Elizabeth28 in forum Access
    Replies: 3
    Last Post: 07-26-2009, 10:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums