this is one of the questions i have been given for a project at university:
8. List details of all the projects, together with the cost of each project. The cost of the project should be calculated from the total fixed cost of all the tasks in the project, plus the labour cost of the work done by the employees assigned to the tasks in the project. The labour cost for an employee is calculated as the annual salary multiplied by the number of days assigned to the task divided by 20.
for the section in bold i am trying to use the sum function, however when i try and run the query it comes back saying
"you tried to excecute a query that does not include the specified expression 'projectID' as part of an aggregate function"
any ideas on what im doing wrong. i feel i will be able to do the rest of the question myself if i can get the sum function working. I have included a screenshot of what tables/fields etc i have put in so far.
Not having a backup on Earth and another on the moon and another on Mars is also a redundancy failure.
Not having a backup in another galaxy is a redundancy failure
How do people work?
You have 1 PC, 1 Laptop and 1 iPhone.
How do you synchronize your photos, videos and documents between 3 different devices? Of course, it's with the cloud, right?
Are you going to use an external SSD to share files between your PC, Laptop and iPhone?
"New" Outlook is not even a mobile app (mobile app has Unified Inbox at least), this is just their web app with an added ability to use email account other than Microsoft's.
Question
phoenix-flames
this is one of the questions i have been given for a project at university:
8. List details of all the projects, together with the cost of each project. The cost of the project should be calculated from the total fixed cost of all the tasks in the project, plus the labour cost of the work done by the employees assigned to the tasks in the project. The labour cost for an employee is calculated as the annual salary multiplied by the number of days assigned to the task divided by 20.
for the section in bold i am trying to use the sum function, however when i try and run the query it comes back saying
"you tried to excecute a query that does not include the specified expression 'projectID' as part of an aggregate function"
any ideas on what im doing wrong. i feel i will be able to do the rest of the question myself if i can get the sum function working. I have included a screenshot of what tables/fields etc i have put in so far.
Link to comment
https://www.neowin.net/forum/topic/631448-sum-function-in-access-03-expression-builder/Share on other sites
2 answers to this question
Recommended Posts