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.
Lynn
Thanks in advance for any help.
Lynn