Good afternoon!
I just typed up a detailed question here then firefox crashed, so Im gonna be brief on this second go around.
Im creating a point of sale, and sales tracking system for a small lightly used storefront for internal employees.
It works flawlessly and is pretty cool.
Im almost done, I just need ot make it pretty, but I have 1 bare bones complication.
I created a query that pulls up individual "Orders" within a transaction, then takes the price of the product, and multiplies it by the quantity then totals it in real time in the subform. Its pretty cool, and Im proud.
However, I want 1 more thing.
I want to have a tex box at the bottom of my form that calculates the SUM of the total column (currently named Expr1 ther ein the subform) for all the related records that pull up in the transaction so we know how much the total order costs all together.
I tried creating the text box at the bottom and using this formula: =Sum([QueryOrderTotal]![Expr1]) .... but It comes up with an error. Anyone know how I can do this?