Results 1 to 3 of 3
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, USA
    Posts
    901
    Thanks
    153
    Thanked 11 Times in 10 Posts

    Parameter Query (2003)

    My database has fields for YearOn and YearOff, which are the years that people came and left our organization. I want to make a parameter query where I can enter a year, and the query returns the records of all those who were in the organization during that year. I've got the query, but I have to enter the year twice for whatever year I'm interested in.

    How do I make it into a parameter query, where I just enter the year in a dialog box?
    Attached Images Attached Images
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 30 Times in 30 Posts

    Re: Parameter Query (2003)

    Enter

    <=[Specify year]

    in the criteria for YearOn, and

    >=[Specify year]

    in the criteria for YearOff.

  3. #3
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, USA
    Posts
    901
    Thanks
    153
    Thanked 11 Times in 10 Posts

    Re: Parameter Query (2003)

    Works great! Thanks.

    So much of this stuff is SO simple (once you know it, that is!).
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

Posting Permissions

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