New here, should I be using a query ?

[Silciv]

Hi all hope you can help me. Here is what I am trying to do, I have a field "Quantity Received".These are against a field called "Part Number" I want to be able to take the Quantity Received value and put it against the Part Number so that it tells me how many of the Parts have come in. For example I have ten vehicles, therefore the Part Number occurs ten times, If I only have two of those come in then I need the query to show yes for only two of the Part Numbers and no for the other eight.
Hope I haven't confused any of you and you can help me out.

 

[Cagliostro]

You should use queries alway when you need data. Tables are for storing data, but queries for manipulating/storing/transforming/reading it. It is a much more than read data directly from a table.
In my opinion you need a query like

select PartNumber, sum(QuantityReceived) from yourTable
grou by QuantityReceived

instead of yourTable you will put the tables name from your access db. John Fill

ivfmd@mail.md

 

[THoey]

John, good answer, but don't you want to GROUP BY PartNumber? Terry M. Hoey