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.
Save 15% on the Insta360 Link 2 4K Webcam, now available at the lowest price by Taras Buria
Insta360 is known for its high-quality 360-cameras, but the company also offers high-end webcams for those who want to elevate their video calls or streaming. Right now, the Insta360 Link 2 4K webcam is available at a new all-time low price, saving you 15% off the standard MSRP.
The Insta360 Link 2 is not your standard 4K webcam. This camera is mounted on a two-axis gimbal that physically pans and tilts to follow you as you move around the room. You can also set boundaries to prevent the camera from capturing certain areas and control it with gestures for a hands-free experience.
The camera itself has a large 1/2" 4K sensor that captures more light and details with HDR and low-light mode support. A larger sensor also means a more natural bokeh effect. Built-in microphones support voice focus and voice suppression, and the camera can balance your voice with background music.
Other features include additional modes, such as whiteboard mode, DeskView mode, portrait mode, and privacy mode. The latter tilts the camera down after 10 seconds of inactivity (you can also push it down manually). The Insta360 Link 2 is also remotely operated with a dedicated phone app, plus its desktop software lets you adjust features like background, filters, and more. Insta360 Link 2 4K Webcam - $169.99 | 15% off on Amazon US
Insta360 Link 2 4K Webcam Tripod Bundle - $195 | 15% off on Amazon US
This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here.
Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days.
As an Amazon Associate, we earn from qualifying purchases.
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