Most places in the universe will kill life instantly - instantly! People say "oh, the forces of nature are just right for life." Excuse me. Just look at the volume of the universe where you can't live. You will die instantly.
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.
Reply from Alex Hedley:
Are any of the rows NULL or showing invalid values?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Work Order Lessons.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
