Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: Multiple Queries

    Hey Guy's

    My content analyst has created a access database for items that we purchase from various Sysco operating companies and we are trying to find a way to create just one query which will allow us to create a report which will search all queries accross all operating companies and the purchases. The way the queris work now is creating a report we have to type the name of the opco twice, once for item availbility and second for purchases. The queries are combined of one to many relationships. I just would like to know if this is possible.

    Baylock

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, it's possible. If you had a custom dialog box (form) that let the user select the opco, then the queries could refer to the dialog box for their input.
    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
    Mar 2009
    Posts
    2

    Multiple queries

    Would yoube able to give me an example?

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I don't have enough time to put mock ups together these days.

    A custom dialog box is simply a form. On that form you might have a combo box, for your opco, perhaps called cboOpCo.

    Then queries could refer to it with such:

    SELECT *
    FROM TableName
    WHERE OpCoFieldName = Forms!MyCustomDialog!cboOpCo

    That kind of thing.
    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
  •