If you rolled the labor up, in this case totaled at 50, then dividing it by 3

for the number of parts will give false information. Fan belt, oil, and oil

filter do not take identical labor times to install.

And again - tire, valve stem, and balance weights.

- Brake pads, turn disc, and brake fluid.

--

KARL DEWEY

Build a little - Test a little

kourkoutas said:

This makes calculation problem. It calculates the labour for each part

separately.

ie. if labour is 50 and there are 3 parts (a,b and c) that cost 10 20 and

30 respectively, it performs the following operation:

(50+10)+(50+20)+(50+30), when it should be 50+(10+20+30). Is there a

function to divide the labour with the number of records that correspond to

each job.

Christos Evripidou

kourkoutas

Ken Snell (MVP) said:

Try this:

=Sum([Labour]+([Quantity]*[Price Sold]))

--

Ken Snell

<MS ACCESS MVP>

I have three tables, Entries, Jobs and Parts. These three tables are

related

with one-to-many relationships, from left to right.

i.e. one entry - many jobs

one job many parts

Among the other fields, in the parts table there is quantity and price,

and

in the jobs table labour. Additionally, I created a 3-level report where I

calculated, using a calculated field, the total of each job using the

expression:

=[Labour]+Sum([Quantity]*[Price Sold])

Now, I want to create another calculated field to sum up all the job

totals

for each entry. I tried the following expression, but it displays a

message

that it could not have an aggregate function:

=Sum([Labour]+Sum([Quantity]*[Price Sold]))

Any idea how to make this calculated field?