Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Tottihope

    Access Subform SUM() Displays #Error for calculated field on main Access Form

    Thanks a lot dhookom for your solution, That cleared the confusion on another aggregate which the total bill on that order. But I was also interested in the Grand Total which is the SUM() of all order or subtotal. I would highly appreciate a hint on how to go about pulling that Grand Total off...
  2. Tottihope

    Access Subform SUM() Displays #Error for calculated field on main Access Form

    I am trying to calculate the Grand Total for my Order Items on my main order form using the =SUM() function. It displays on the subform itself but errors out on the main form. I find it hard to figure out where I went wrong after many days and my Acces skills are beginner level. Solutions...

Part and Inventory Search

Back
Top