Search results

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...

If this were a table Amount Job_id Crew_id $100 1 3 $200 2 4 $400 2 4 $600 2 3 $750 2 3 $800 3 7 and i...

i have joined a jobs table and payout table together and performed a query. however i would like to perform SUM by the job_id but crew_id fields are duplicated. (the payout table comes from a subform that doesnt differentiate crew type so my SUM totals all the payouts whereas i want to sum...