K
kourkoutas
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?
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?