Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008

    Filtering my report

    Hi I am having problems filtering two of my subreports on my forms :

    frm_operator_search & frm_school_search

    These search forms are set up to search my database (attached minus all sensitive data) to create a list of schools or operators (depending on the form) and thier relevant transport routes.

    The form is filtered using either text for the school name or a combo box for Local Auhtoirity. this is all set up and working fine. Some school are served by more than one Athority and some operators also work for more than one authority, my tables are all normalised and this again is working fine.

    If you search the form by Authority in the subform only that Authority which you searched for's routes come up, which is what I want..... BUT in my report form all Authorities routes to the school or provided by the operator are listed.

    e.g. if you search for Amman in the text box & select city and county of swansea from the combo box only city and county routes are shown in the form. However if you preview the report both Neath and Swansea routes are shown, when I want Neath routes filtered out.

    Anyone out there have any suggestions as to how the report can be made to filter the results properly?

  2. #2
    Join Date
    Sep 2008


    Hi all,

    Having a similar problem on filtering reports as well. Doing an Access assignment on a call centre database - need to design a way to make reports to show the contacts that were never cold called before during a period of time.

    What I have set up now is a query that has a calculated column with an IIF statement:
    Expr1: IIf([CallDate] Between [Enter Start Date: MM/DD/YYYY] And [Enter End Date: MM/DD/YYYY],"Potential Net New Call","Not Net New Call").

    The report generated so far is 2 columns that shows the number from the underlying query from above and the total number of calls made to the contact. If the two numbers matches and is not zero, then we have a net new contact within the period of time. But this means the report looks at all the contacts called and generates a 60+ page report. Is there a way to 1)filter on the report, 2) create a report on the report, or 3) simply better way to do this?

    Thanks so much in advance for your help. Much appreciated.


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

Similar Threads

  1. Replies: 0
    Last Post: 10-24-2008, 11:20 AM
  2. Replies: 0
    Last Post: 08-17-2008, 12:19 PM
  3. report prints blank page at end of report
    By darrellx in forum Forms
    Replies: 0
    Last Post: 03-14-2006, 08:51 PM
  4. Filtering using a Substring Help
    By r_walk76 in forum Forms
    Replies: 2
    Last Post: 01-11-2006, 07:13 AM
  5. Automatic Filtering when Opening form
    By Karyn-2000 in forum Forms
    Replies: 1
    Last Post: 12-03-2005, 09:29 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