Results 1 to 2 of 2

Thread: Query question

  1. #1
    Join Date
    Mar 2006
    Posts
    2

    Unanswered: Query question

    I want to create a query that pulls specific names out of a number of fields. I have 10 fields labeled, Operator1,Operator2,etc.

    I created a query where I used the criteria, Between[Start Date] and [Stop Date] to only select from a specified date range. What criteria could I use to pull say Bill Bunker's name from my 10 Operator fields?

    Thanks,

    Frank

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Read this.

    Once you have read that, do you have a good reason why you have 10 fields for operators?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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