Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

ignoring certian fields when searching for duplicates

Discussion in 'Information Technology' started by JackCGW, Nov 1, 2005.

  1. JackCGW

    JackCGW
    Expand Collapse
    Guest

    I have a query that searches an "Orders" table for [MaterialDescription],
    [MaterialCost] and [MaterialTax]. It hides duplicates based on all 3 fields;
    then a list box is populated with the results. The idea is to search for
    previously entered materials and use them as a selection for new orders.
    This way I only have to ype them once. I am trying to have the query ignor
    the MaterialCost field and then show only the most recent entries. This will
    make it possible to update the price if a particular Material in and then
    populate the list box with the new cost the next time it is opened.
    Thanks for any help
    Jack
     
  2. Loading...


  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    See The Access Web article:

    http://www.mvps.org/access/queries/qry0020.htm

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "JackCGW" <GCW@discussions.microsoft.com> wrote in message
    news:15CDDF73-3B86-4913-BB2C-CA4F2148B34D@microsoft.com...
    >I have a query that searches an "Orders" table for [MaterialDescription],
    > [MaterialCost] and [MaterialTax]. It hides duplicates based on all 3
    > fields;
    > then a list box is populated with the results. The idea is to search for
    > previously entered materials and use them as a selection for new orders.
    > This way I only have to ype them once. I am trying to have the query
    > ignor
    > the MaterialCost field and then show only the most recent entries. This
    > will
    > make it possible to update the price if a particular Material in and then
    > populate the list box with the new cost the next time it is opened.
    > Thanks for any help
    > Jack
     
  4. wuyouren

    wuyouren
    Expand Collapse
    Guest

    "JackCGW" <GCW@discussions.microsoft.com> дÈëÓʼþ
    news:15CDDF73-3B86-4913-BB2C-CA4F2148B34D@microsoft.com...
    > I have a query that searches an "Orders" table for [MaterialDescription],
    > [MaterialCost] and [MaterialTax]. It hides duplicates based on all 3

    fields;
    > then a list box is populated with the results. The idea is to search for
    > previously entered materials and use them as a selection for new orders.
    > This way I only have to ype them once. I am trying to have the query

    ignor
    > the MaterialCost field and then show only the most recent entries. This

    will
    > make it possible to update the price if a particular Material in and then
    > populate the list box with the new cost the next time it is opened.
    > Thanks for any help
    > Jack
     

Share This Page