• 0

sum function in access 03 expression builder.


Question

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.

post-248496-1208211758_thumb.jpg

2 answers to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • So, they catched 2-3 of the bad guys. The other 30.000 went undetected.
    • 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.
    • They need to pay me more than that!
    • Yep, same. One less source of brainrot to boot.
  • Recent Achievements

    • First Post
      Uranus_enjoyer earned a badge
      First Post
    • Week One Done
      Uranus_enjoyer earned a badge
      Week One Done
    • Week One Done
      jfam earned a badge
      Week One Done
    • First Post
      survivor303 earned a badge
      First Post
    • Week One Done
      CHUNWEI earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      428
    2. 2
      +FloatingFatMan
      199
    3. 3
      snowy owl
      192
    4. 4
      ATLien_0
      187
    5. 5
      Xenon
      142
  • Tell a friend

    Love Neowin? Tell a friend!