Time & Billing

[andsweet]

I am trying to adapt the Time & Billing sample DB that ships with Access 2000. There is a Workorders Parts subform inside the Workorders Form. I have tried adding an extra 2 columns in the subform ie. markup percent and total cost of parts (includes unit price, VAT and markup) This all works well but when I try to get this info onto the main form (Workorders) the value will display on a single entry and not the total of all the Total Costs. I believe that I have displayed the form syntax correctly (single value is displayed). I tried to use =Sum(express ) to total this but I get #Error or #Name.

Can anyone suggest possible causes.
Thanks

 

[ansentry]

Post a copy and someone will have a look for you

 

[andsweet]

Unfortunately I cannot attach the DB as the compressed file exceeds the permitted value.

 

[CEH]

As Ansentry was refering... hard to do without seeing it... but.... If I'm guessing correctly.. Put your "markup" and "Total" in the subform. On the main form reference the subform with something like... =nz(WorkOrderSubform.Form!txtTotalCost,0)
in an unbound textbox
Of course using your subform name and textbox name.

 

[andsweet]

Thanks but that did not work either. It appears that if I use the =nz expression it works but I only get the total for the one entry. If I use the =Sum expression then I get #Error and #Name. Hope this helps.

 

[ansentry]

Have a look at my sample posted here.