Sum particular fields only

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

Guest

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
 
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


Leonie said:
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
Click to expand...
[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?
 
Back
Top