automated entry of parameters?

Discussion in 'Microsoft Access Queries' started by JR, Sep 22, 2004.

  1. JR

    JR Guest

    I gather and disseminate data for several different
    customers whose requirements for the same data elements
    varies with the model they are feeding.

    One table is set up as follows:

    Org ID | Location | POSTURE | PHASE | Rate

    Posture and Phase are variables with 5 and 4 possible
    variables respectively which give 20 possible combinations.

    I must periodically rebuild the table data. I use an
    append query to do that BUT the query design is such that
    Posture and Phase are expressions (1 and 2 respectively).
    Each time I update the table I am prompted to enter
    parameters for the two expressions (Posture and Phase).
    There has GOT to be a better way (such as using a form
    that allows me to select the combinations of Posture and
    Phase from a list).

    Any help will be greatly appreciated.
     
    JR, Sep 22, 2004
    #1
    1. Advertisements

  2. JR

    Mark Hyland Guest

    Hi,

    You could create two combo boxes on a form, which show the values for the
    two fields (Posture and Pasture), and then in the query, refer to the
    fields on the form, for the criteria.

    Your criteria would be something like

    forms![formname]![fieldname]

    This way, when the form is opened, the value you select will pass to the
    query and act as a filter.

    Hope this helps

    Mark

    This information is provided "as is" and expresses no warranties or confers
    no rights.
     
    Mark Hyland, Sep 23, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. dwa

    Automated Import

    dwa, Feb 27, 2004, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    129
  2. Brendan Mather

    Automated Field entry based on another field

    Brendan Mather, Mar 17, 2004, in forum: Microsoft Access Queries
    Replies:
    5
    Views:
    303
    John Vinson
    Mar 18, 2004
  3. Guest
    Replies:
    1
    Views:
    133
    Guest
    Apr 6, 2007
  4. Guest
    Replies:
    4
    Views:
    216
    Guest
    Apr 23, 2007
  5. Marshall Barton

    Re: Double entry of parameters used in query

    Marshall Barton, Oct 7, 2009, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    177
    Marshall Barton
    Oct 7, 2009
Loading...

Share This Page