Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    parameter query (2003)

    I want to create a parameter query that has 8 parameters. The first would ask for the Client Mgr name. Then the 7 other fields the parameter for each would be [Gain or Loss]. What I want to see is Gain in the first field or a gain in the second field or a gain in the third field and so forth. I want a gain in any of the seven fields using or. Is this possible for a parameter query and if so how would I set it up. The seven fields would be all Gains with or - or all Losses with OR. Just that for each field, at least one of the seven has to have a gain for each record. I hope this makes sense.

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: parameter query (2003)

    Linda, if you're only looking for managers with 'Gain' records (no user input on the query, other than manager name) you could use something as shown below):
    <IMG SRC=http://i40.tinypic.com/2pqmcsh.jpg>

    If you want more user interaction, the only way I can think of to prompt for input in a query (without a prompt for each field) would be to use a form. The concept of defining a variable is stomping loudly in my brain, but I don't know how to do it/use it in a query. I can show you how to set up the form though.

    Edit: as I was tinkering further with this; apparently, so long as your prompt text (ie [Enter 'Gain' or 'Loss']) is exactly the same in each field you are searching, your user will not be prompted multiple times.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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