dynamic list menu

Results 1 to 2 of 2

Thread: dynamic list menu

  1. #1
    Join Date
    Dec 1969

    Default dynamic list menu

    im pulling the values for my list box out of a field in a access database what the best way to prevent duplcated data beeing put into the list menu ? say i have 3 item with and price of 5 i only want one 5 to show in the list box

  2. #2
    Join Date
    Dec 1969

    Default You can set up the query...

    ...to select only "distinct" values:<BR><BR>SELECT [hl="yellow"]DISTINCT[/hl] Price FROM PriceTable ORDER BY Price;<BR><BR>Oliver.

Posting Permissions

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