Results 1 to 4 of 4

Thread: Filter Question

  1. #1
    Join Date
    Feb 2008
    Posts
    28

    Unanswered: Filter Question

    Hello,

    I have a Query and a Form based on that Query. I would like to add a button to the Form that opens the Query and filters that Query based on a field in that Query called Type. I cannot seem to get the filter macro to work properly (most likely because I have almost no clue how this works). Can someone give a suggestion on what such an expression would look like? I currently have a button which opens the Query and shows all data.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I don't get it. Why not just filter the form?

    Filtering query results is highly irregular since a query has a WHERE clause.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2008
    Posts
    28
    Startrekker,

    OK. I figure I am not asking the right question. I have a table of all hours worked by all employees for all clients during all months. I want to be able to pull up only those records of a selected month, or only those of a selected employee, or only those of a selected client. What is the best way to do this?

    Tim

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yeah, I'm detecting a communication problem here too.

    I would create a custom reporting dialog box that allows the user to choose a month, client and/or employee and when they hit the preview button a report shows the list of hours details that match the criteria they've specified in the reporting dialog box.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •