Microsoft Access – 06 Create a subtotal field on a form

About this tutorial:

Video duration: 7:32
How to create a subtotal field to sum an order

Incoming search terms:

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

19 thoughts on “Microsoft Access – 06 Create a subtotal field on a form

    Alexander Enos

    (October 10, 2018 - 11:46 am)

    Thank you so much. This has helped me a lot! How would I integrate receipts pls?

    Suhbat Ismatullah

    (October 10, 2018 - 11:46 am)

    hello every one
    where I can find this video ?
    Microsoft Access – 03 Create a simple store invoice system tutorial create tables


    (October 10, 2018 - 11:46 am)

    Sir i am facing a problem that is the total in main form is not calculating

    Kaili Damaske

    (October 10, 2018 - 11:46 am)

    Hi, so I followed your steps exactly and my total order is blank…. not sure why everything is done exactly like you did! PLEASE HELP!!!!

    Anlu Uy

    (October 10, 2018 - 11:46 am)

    HI SHAD i created an invoice form with Sub form like yours. now how can i update the product stocks in the product database i cannot create an update query using the subform in the Form i made. can you show me how thanks so much. im having a hard time. I've been watching some videos of how to create an update query but it seems it only works in a single form invoice. Thank so much and hope you can help me out

    Kegen Rodrigues

    (October 10, 2018 - 11:46 am)

    How can i store the value of Order Table (dynamic value) to a separate field of a separate table?

    Varunyu Apisaksiri

    (October 10, 2018 - 11:46 am)

    Hi! This series is great. I use it to learn how to use MS Access and try to develop my business also.
    In the other hand, I have some thing I want to add up from these VDO.
    1. I am both retail and wholesale. How to choose or change price in invoice into wholesale price?
    2. I want to have inventory track function in the application, Could you suggest?
    3. I want to make roughly profit & loss statement, Could you suggest?
    Thank a lot for These VDO ^.^

    Jazuz Uzumaki

    (October 10, 2018 - 11:46 am)

    I don't get an error, but the order total is blank is not showing nothing!

    Andy Bawn

    (October 10, 2018 - 11:46 am)

    good series. one problem. it all works great until you change a price in the product table. it resets all the invoices to the new price making them useless :(. unless there was something in #3 that prevented that, thing is #3 isn't on here ?? 🙁

    Shawn Evans

    (October 10, 2018 - 11:46 am)

    Impressive series.. Helped me out a lot. Access is quirky with the relationships and code and this was really helpful. Thank you Shad..!

    المعز صديق

    (October 10, 2018 - 11:46 am)

    thanks – very usefull

    Pete Fenolio

    (October 10, 2018 - 11:46 am)

    I followed these steps exactly and keep getting #error in the total. Any idea why?

    Sudipta Das

    (October 10, 2018 - 11:46 am)

    Please help. Its showing 0 instead of showing subtotal.

    Miriam Envios

    (October 10, 2018 - 11:46 am)

    please share link of part 3

    Tulsi Achar

    (October 10, 2018 - 11:46 am)

    HI, I use access 2007 and when i put this expression it shows a error "#Name" what should be done

    plz help me out

    Selina Kyle

    (October 10, 2018 - 11:46 am)

    Hi, great tutorial! Will you be adding more content? Like having a discount based on which customer?

    Ian Brown

    (October 10, 2018 - 11:46 am)

    How do you make the price static so that future changes to the price will not change the price on previous invoices?

    Carlos Ruiz

    (October 10, 2018 - 11:46 am)

    Exactly! what I was looking for. Great work. Thanks a bunch!Can I add a request? Could you fill in the products table information by querying another DB (e.g. MySQL) on the fly, instead of having to create a table with the information in Access? Alternatively, keeping an Access table synched with the contents of another Table in another DB engine, using an ODBC connection?The problem is that I already have the products table information stored in another DB engine and I dont want to duplicate information in Access and I also want to avoid having to maintain two separate product information tables simultaneously.


    (October 10, 2018 - 11:46 am)

    how to make this form (invoice) uneditable once completed/closed. Like the one in Northwind DB please.

Leave a Reply

Your email address will not be published. Required fields are marked *