ignoring certian fields when searching for duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
JackCGW said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filling multiple text boxes from a 3 column combobox 3
Field types 4
duplicate Phone search 4
List Box search 4
Duplicate Query assistance 2
Program a Search field 2
DATABASE pulling values from Spreadsheet 3
This will make sense if you read the whole message 8

Back
Top