Results 1 to 5 of 5
  1. #1
    Join Date
    May 2009
    Posts
    104

    Unanswered: Report/Query help

    I need to come up with a way to create a report based on selecting certain criteria. What i have done is created a form where i can select from a combo box the criteria i want. I can only create a report one selection at a time this way. I can create a report that includes all the records and from the report view i can click on the filter button, then select or de-select the criteria to filter the report. I have yet to find out a way to do this in a way that will work in the runtime version. The menu bar is pretty much non-existent in the runtime version. The little pop up window that comes up when you click the filter button is exactly what i want to do but don't i'm not really sure how to accomplish this in a way that will work in the runtime version of access.

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Nothing easier. Look at "DemoQryRptA2000.mdb" (attachment, zip).
    Open Form1 and try.
    Attached Files Attached Files

  3. #3
    Join Date
    May 2009
    Posts
    104
    This is what I have now. But your example tells me you understand what Im trying to do, that is good. In you example you can select from different employee ID's. I want to be able to select multiple ID's. For example I would like to create a report that included ID, worker ID 100 and 101. You only have four criteria to choose from where I will have around 20. If I print out the whole list it would take way too long and a lot of paper. What you have here Is what I have now, essentially one at a time.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    To select multiple employees, you can make the selection part of a table. Either a select flag (Y/N) for each employee (in the employee table) or a separate table that stores the IDs of selected employees... or you can use multi-select list boxes, but I hate them for some reason
    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

  5. #5
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Ok, I think you need something like this,
    look at a Demo, (attachment, zip),
    Form2, Report2 (Record Source).
    Open Form2 and try.
    I think it is what you need.
    Attached Files Attached Files

Posting Permissions

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