Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    1

    Unanswered: Need Help having multiple filterable criteria in a form

    Hello, I am trying to have multiple items to filter by in a form with a sub form.

    The situation:

    I calculate compensation for the sales people in my organization. One of the bonuses I calculate is Key Performance indicators. The sales managers/executives provide me with an attainment. I created a form for them to input the attainments directly into a table. The problem is that I need them to be able to filter by three different things: fiscal quarter, division, and employee. I have created all the parent/child relationships between the form and subform but it still doesnt filter properly. I am using Access 2003 on a windows 7 machine.

    Thanks for any help you can give!
    Attached Files Attached Files

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Please provide some useful information, such as: name of the table(s), name and data type of the columns, name of the forms and controls, etc.
    Have a nice day!

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
  •