Bring Multiple Fields From Sub Form

[mykeld]

I have an invoice report which contains a subform of extra_to_be_billed. The sub form has fields "description" and "cost" then a sum total. However for the jobs which have more than one entry in the subform i can only seem to bring one "description" and its corresponding cost to the MAIN form. by using

=[Extra_To_Be_Billed].[Form]![description] (to return the description and
=[Extra_To_Be_Billed].[Form]![cost]) (its cost)

Is there a way to bring all of the contents of the sub form including the sum total to the Main form??

 

[Pat Hartman]

That doesn't really make any sense. The reason you created the separate table to hold the jobs was because there are "many" jobs for each invoice. How could you determine how many controls you needed to add to the main form to handle "many" jobs? "Many" side data must stay on the subform/subreport.

If you want to sum subform/subreport fields add a footer and add the control to sum there.

You first say you have a report, then you switch to refering to a form. Which is it?