Results 1 to 6 of 6
  1. #1
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397

    Storing filtered reports

    reports are created as you open them. You use criteria to define which month you want to see. So there is no way to store the report detail permanently unless you export to something like excel.

    You need to provide information on what you are actually doing - example data, code you are using etc. I suspect your table design might need adjusting.

  2. #2
    erickemboi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    73

    Storing filtered reports

    I am new in MICROSOFT ACCESS. Somebody please help me. I have filtered reports. Actually I am developing school management system. From the whole school report I have filtered for class 8 JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER and DECEMBER. When I enter pupils marks for January I access the report for JANUARY. Now, with the same students when I edit the month to be February when I access report for JANUARY it is blank. Somebody help me if there is any code to store reports permanently. I want to store reports for a year let's say 2020 and I want to access them in 2021.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You make 1 report. The query behind it will pull data in the date range,be it JAN, FEB...
    use a form with 2 text boxes to set the txtStartDate,txtEndDate.

    the query will look like:
    select * from table where [dateFld] between forms!fMyForm!txtStartDate and forms!fMyForm!txtEndDate

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    If you have to save them at a certain time, consider printing to a pdf file.?

  5. #5
    erickemboi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    73
    Table- STUDENTS TABLE: The fields are ID, LAST NAME, FIRST NAME, CLASS( 1ST GRADE, 2ND GRADE, 3RD GRADE, 4TH GRADE, 5TH GRADE,6TH GRADE, 7TH GRADE, 8TH GRADE), TERM(TERM ONE, TERM TWO, TERM THREE), EXAMINATION TYPE (JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER), PHYSICS, CHEMISTRY, BIOLOGY
    FORMS- I HAVE FILTERED TO GET 8 FORMS. LET'S USE 8TH GRADE FORM
    REPORT- I want each reports for JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER AND DECEMBER from EXAMINATION TYPE with the same children

  6. #6
    erickemboi is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2020
    Posts
    73
    Pdf is the best. How will you access it on the same database

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

Similar Threads

  1. FIltered Report based on filtered SubForm
    By Misterpokey in forum Programming
    Replies: 1
    Last Post: 03-16-2020, 08:27 AM
  2. Allow user to create custom, filtered reports
    By zzzjoshzzz in forum Access
    Replies: 5
    Last Post: 05-01-2015, 12:33 PM
  3. Reports filtered by Month
    By Douglasrac in forum Access
    Replies: 3
    Last Post: 01-27-2011, 05:01 PM
  4. Can't keep dates filtered on my reports!
    By Mr. Coffee in forum Queries
    Replies: 5
    Last Post: 12-02-2010, 11:27 AM

Tags for this Thread

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