Main form sum from sub form

Joined
Jun 8, 2011
Messages
2
Reaction score
0
Hi all I am very new to access and I hope I am posting in the correct place. Please forgive me if not. Anyway I am trying to create an inventory database. I have a Main form that I want to show reorder levels of a product. Each entry on the Main form shows a specific product with a sub form that is a datasheet list of customers that buy the product listed on the main form. One column on the sub form shows the monthly usage of each customer for that product. I want to sum all rows in the monthly usage column in one text box on the Main form. Some products may have one customer usage and some may have 10 customers with usages. Is there an expression that will help me with this. I hope this makes sense. Please let me know if more information is needed.
Thanks in advance for any help. :D

Lynn
 

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

Top