Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that is the bases for a report. The query two fields
(number-errors, and cost-errors) that I need to totaled. I am trying to use
the following to do the job:

TotalErrors: ([number-errors])
TotalCost: ([cost-errors])

I have tried coding these several ways. Please tell me how to do this I will
include the SQL code.

SELECT DISTINCTROW esthist.[bid-number], esthist.[bid-suffix],
esthist.[job-name], esthist.tier, esthist.[est-hours], esthist.[act-hours],
esthist.[number-errors], esthist.[cost-errors], esthist.[discount-price],
esthist.[discount-date], esthist.[date-est], esthist.[date-check],
esthist.estimator, ([cost-errors]) AS TotalCost, ([number-errors]) AS
TotalErrors
FROM esthist
WHERE (((esthist.estimator)=[Forms]![ReportSelect]![estselector]))
ORDER BY esthist.[bid-number], esthist.[bid-suffix], esthist.estimator;
 
Let the report to the totals (I'm assuming that these two fields are numbers)
the query provides the data and the report may or may not show the details,
but would show the totals. The total would be like:
TotalErrors is the field and the value "= sum([number-errors])" and the
TotalCost field would have the value of "=sum([cost-errors])"

Is this what your looking for or did I miss what you are looking for?

SteveD
 
Back
Top