Search results

i am trying to do the exact same thing as u are. If u get the answer please post or private message me. nedd to bring all my fields form my subform to my invoice as well. Thanks in advance

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

here's the actual query but wont that just return the job_id. in my example job_id 2. i want to sum the rows where job_id=2 and crew_id=2 , then job_id=2 and crew_id=7 SELECT * FROM [SELECT jobs.id, jobs.name, jobs.size, jobs.roof_crew_rate, jobs.size*jobs.roof_crew_rate AS roof_pays...

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