4 hours ago: Our file storage provider is running maintenance today. If any videos don't load, wait a minute, refresh the page, and try again. Sorry for any inconvenience.  Dismiss

 I am, and ever will be, a white-socks, pocket protector, nerdy engineer... Science is about what is. Engineering is about what can be.-Neil Armstrong

 Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum Access Troubleshooter Access Developer Network Access AI Bot ------------ Excel Courses Excel Index ------------ Code Vault Testimonials Tip Jar Advice for Consultants

 Home > Courses > Access > Seminars > Work Order > Lessons
 Back to Work Order Lessons    Comments List
 Shallena A  7 years ago
Hi Alex,  I figured out the reason i could not delete something.  I had turned off the Record Selectors option so there was no way to choose a record to delete.  But as for the formula.  I have double checked and triple checked and the only thing that is different is that i am trying to SUM  a column of numbers that have formulas in them.  This is the formula in the field named SubAmount =([JobTotal]*[percentageperformed])*([subpercent])  (so maybe one sub crew did 50% of the work and another sub crew did 50% of the work and the subcrews gets 75% of the JobTotal) At the bottom of the form I have a field called TotalSubCost and the formula there is =Sum([SubAmount]).  Then when i closeout the sub crew form i have a formula on the purchase/work order to show the total sub cost and the formula there is =DSum("SubAmount","Subcontractorlaborf","purchaseorderid=" & [PurchaseOrderID]).

I copy and pasted all of those formulas and names.  On the subcontractlaborf the totalsubcost shows \$0.00 no matter what is entered.  And the PurchaseOrderF shows #Error in that box.

Are any of the rows NULL or showing invalid values?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Work Order Lessons.