sum based on if...then...

[JoelSaltzman]

I have a products form that lists the id,name, TOTALUNITS, CUSTOMERUNITS, OVERSTOCKUNITS, and SHOWROOM UNITS of an item.
there is a subform for that has where the current product is allocated to. ie customer name, po #, qty

basically i need the total fields to show the sums from the subform based on allocation.
ie: customer total on productsform = sum of all records in subform that have a PO#
ie: overstock total = sum of all records in subform that have "overstock" in the name field
ie: showroom total = sum of all records in subform that have "showroom" in the name field

take a look at the attached db to see the product form and subform that i am talking about.

Thanks.

 

[Swannie]

You should look up the Dsum function, either in access help, or search for it in this forum, as there are numerous threads that cover this topic.