Sum particular fields only

[Leonie]

Newbie here, What's the easiest way I can sum only some records in a query?

I have a query generated from two tables, with the related fields of [Batch Number]. When a batch number is created, this is the base record. When something happens to a batch (eg, it is moved), a second table is used, drawing the batch details from the base record. So each time a batch number is entered, it draws from the original record (table) and generates a new record in the second table. My query is displaying every record for a given batch number. How can I display the sum of units moved for each batch number?

Thanks,
Leonie

 

[Wayne Morgan]

It sounds as if you're trying to keep track of an inventory. You may find
some tips here:

http://users.bigpond.net.au/abrowne1/AppInventory.html

--
Wayne Morgan
Microsoft Access MVP

Newbie here, What's the easiest way I can sum only some records in a query?

I have a query generated from two tables, with the related fields of

[Batch Number]. When a batch number is created, this is the base record.
When something happens to a batch (eg, it is moved), a second table is used,
drawing the batch details from the base record. So each time a batch number
is entered, it draws from the original record (table) and generates a new
record in the second table. My query is displaying every record for a given
batch number. How can I display the sum of units moved for each batch
number?