Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    UK
    Posts
    8

    Unanswered: Selective Multiple Query Criteria

    I have a number of queries in which the WHERE criteria is an employees surname. However in two cases multiple employees share the same surname and the results are combined (e.g. Courses attended).

    Each employee has a unique ID number (which I'd prefer to use) but my users prefer to use Surnames (easier to remember). Is it possible to request further criteria (i.e. ID number) only when multiple recordsets occur based upon the original one.

    Hope thats clear enough

    Graham

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    You could show the multi recordset in a popup form for the user to select the person they wish, upon first name / birthdate.

    You could then extract the ID and go back to the original form, filtering on ID.

    Regards

  3. #3
    Join Date
    May 2004
    Location
    UK
    Posts
    8

    Selective Multiple Query Criteria

    If I use a pop-up form how do I link the pop-up selection back into the query? I assume I have to run the SQL in some sort of VBA script linked to the form?
    Also how do I get the form to only appear when multiple recordsets result?
    Any pointers will be gratefully accepted.

    Regards

    Graham

Posting Permissions

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