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.
Borderlands 2 is free on Steam to grab right now by Pulasthi Ariyasinghe
The fourth installment in the main Borderlands series is only a few months away from launch, and now there's a good opportunity for new players to see what all the excitement is about. Developer Gearbox today launched a giveaway for Borderlands 2, offering the base game for all PC gamers to claim for free and play through its campaign. The promotion is running on Steam, making it an easy grab for most.
The 2012-released action RPG takes players to the lawless planet of Pandora for a humorous adventure concerning a rebel group going up against the fan-favorite tyrannical boss, Handsome Jack. Taking the role of Vault Hunters searching for a grand treasure on the planet, the characters Axton (Commando), Maya (Siren), Zer0 (Assassin), and Salvador (Gunzerker) are available to play in the base game.
Each Vault Hunter has their own skill trees and ultimate abilities, letting players mix and match many of their play styles when progressing through the campaign. However, perhaps the most important aspect of the Borderlands series is the guns. The looter shooter elements of the title mean that there are countless weapon and gear variations, each coming with unique stats and effects that vary depending on the rarity. Borderlands 2 supports up to 4-player cooperative play with drop-in, drop-out multiplayer. Your character's loadout and progression will follow you for any games you join as well.
The Borderlands 2 giveaway on Steam is live right now. It's slated to come to an end on June 8 at 10am PT. For those looking to expand on the Borderlands universe after grabbing the freebie, all the games and their massive number of DLCs are discounted as part of a franchise sale on Steam right now too.
Don't forget that PC players can also pick up Bethesda's Deathloop right now for free as well, with that promotion currently running on the Epic Games Store.
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