Expand|Select|Wrap|Line Numbers
- SELECT qryTonnageSelect.Jobs_Job_ID, qryTonnageSelect.SumOfTransactions_TonsNetWeight, qryProfitability.Margin, jcjob.name, qryProfitability.SumOfcost, qryProfitability.SumOfSumOfcost, qryProfitability.DollarMargin
- FROM (qryTonnageSelect INNER JOIN qryProfitability ON qryTonnageSelect.Jobs_Job_ID = qryProfitability.jobnum) INNER JOIN jcjob ON qryProfitability.jobnum = jcjob.jobnum
- ORDER BY qryTonnageSelect.Jobs_Job_ID;
I would prefer it keep the record and either leave the field null or replace it with a 1. Is there a way to do this. The following is the state of the query when I became stumped. Please help. Thank you.
Expand|Select|Wrap|Line Numbers
- SELECT qryTonnageSelect.Jobs_Job_ID, qryTonnageSelect.SumOfTransactions_TonsNetWeight, qryProfitability.Margin, jcjob.name, qryProfitability.SumOfcost, qryProfitability.SumOfSumOfcost, qryProfitability.DollarMargin, qryPaverHourGroupforTonsRep.SumOfSumOfhours
- FROM ((qryTonnageSelect INNER JOIN qryProfitability ON qryTonnageSelect.Jobs_Job_ID = qryProfitability.jobnum) INNER JOIN jcjob ON qryProfitability.jobnum = jcjob.jobnum) INNER JOIN qryPaverHourGroupforTonsRep ON qryTonnageSelect.Jobs_Job_ID = qryPaverHourGroupforTonsRep.jobnum
- ORDER BY qryTonnageSelect.Jobs_Job_ID;