Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Derby, England
    Posts
    38

    Unanswered: select lead week based on lowest price

    hi i have a form containing data from different suppliers for one product. Each supplier has a supllier ID, Name, lead week, price.

    Based on the lowest price is there away i can show on another unbound field the lead week. The lead week is that of the best price
    I have tried endless amount of ways to do this but have not succedded

    Can anyone help.

    Please check the picture as this would make things clearee

    many thanks
    Attached Thumbnails Attached Thumbnails picture.JPG  
    Kabir Hussein

    http://www.angelfire.com/theforce/precious/index.html

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Select *
    from table
    where price = (select min(price) from table)
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Dec 2003
    Location
    Derby, England
    Posts
    38
    hi

    thanks for the reply but are you doing this from a query as i am trying to do the lead week thing from a subform which is connected to main form.

    Do you know anyway i could do this from a form.

    thank you
    Kabir Hussein

    http://www.angelfire.com/theforce/precious/index.html

Posting Permissions

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