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.
If people haven't learned from Trump University, Trump Steaks, Trump Casino, Trump Coin, Trump NFT, and etc. then they deserve to lose their money to this too.
It's insane how there's a base of people out there that will buy this and other stuff from him, like a cult leader, it's insane. It's clear as day that they're getting played/swindled but w/e. Who am I to say what someone else does with their money? Spend away, just don't moan about it later when you're on tough times.
FU M$ all the way to hell.
Local admin account and me being able to log in to my machine offline and decrypt anything mine > either this or no more M$ for me.
The grift is strong in this one, like his NFT's and coins.
America is broken on all levels, but some people will fall for this and call it the best phone ever.....
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