Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Location
    Somewhere on the 3rd Rock
    Posts
    93

    Unanswered: Enter Parameter Value

    I would like to make the db easier to use, I have 4 departments and would like to have the parameter value be a combo box instead of having to type in specific data.

    I also have 50+ sites and need to run site reports from time to time and would like to have this the same way,

    i.e.
    department 1
    department 2
    department 3
    department 4

    and
    site 1
    site 2
    site 5
    etc...

    any suggestions on this

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    maybe this can help. a silly demo of pulling stuff from a form to build SQL. it includes a combo and other stuff besides.

    izy
    currently using SS 2008R2

Posting Permissions

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