Results 1 to 3 of 3
  1. #1
    huv123 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2011
    Posts
    6

    Filtering report

    I know this is pretty simple but cant work out how to make it all work together.



    I know how to filter a report using a form, I know how to create a report that shows counts rather than individual records, but I dont know how to produce a report that shows counts, with the ability to filter the data that is used to produce the counts (according to dates entered into a form).

    Right now my access file is a simple table and form setup. A research assistant needs to enter details like whether the person was screened, did they pass the screen and so forth. I want to produce a report that shows for example:

    No. of people who did not get screened: ___
    No of people who screened but did not pass:___

    etc...

    Normally I would setup a query based on my table data, with columns such as:

    No Screen: Count(if([RecievedScreen]="No",0))

    which I would then use as the control source for a text field on the report.


    However I would also like to introduce the ability for a person to narrow the period of time that this report represents, by entering the start date and end dates for the period into a form, and then clicking on a button on that form to open the report. The best example of this is here: http://allenbrowne.com/casu-08.html

    If you could at the very least describe me the basic setup of this I will hopefully be able to work out what to do.

  2. #2
    alansidman's Avatar
    alansidman is offline Life @ 7100'
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,446
    If I understand what you are asking, then this may be helpful

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

    Alan

  3. #3
    huv123 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2011
    Posts
    6
    Many thanks. I think i was able to work it out and have tested it with some dummy data but it was more trial and error than any specific knowledge. I enjoyed watching this.

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

Similar Threads

  1. Report filtering
    By banjo1t in forum Reports
    Replies: 4
    Last Post: 01-26-2011, 06:43 AM
  2. Report Filtering..
    By banjo1t in forum Reports
    Replies: 1
    Last Post: 01-24-2011, 06:56 AM
  3. Filtering in a report
    By SIM_2009 in forum Reports
    Replies: 1
    Last Post: 10-06-2009, 04:22 AM
  4. Report Filtering
    By HM1 in forum Reports
    Replies: 2
    Last Post: 07-06-2009, 06:06 AM
  5. Filtering my report
    By ldarley in forum Reports
    Replies: 1
    Last Post: 09-05-2008, 09:14 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
  •  
Tech Forums: Microsoft Office Forums