Create Queries with Calculated Fields and Aggregate Functions

Create a new field in an Access database query that is a formula/calculation based off of an existing field. Use aggregate functions like average and sum to display summary data about query results.

[JdawgtheMaxx]

Thank You So Much!!! Been stuck on a problem like this for hours with no idea how to do it! You helped me get through it in less than 10 minutes.

[jamesedwardsjr]

Thank you Ralph for the video tutorial; you helped jump start the learning curve in writing expressions; and the zoom function tip improves visibility to write out the syntax. I look forward to watching more of your videos pertaining to access and working with SQL's.

[r_b]

Great set of Access tutorials. Thanks Ralph!

[mybitch]

Awesome thanks! This will most likely help me get through my Admin Prelim tomorrow, haha! ;)))

[SixMinutesSmarter]

It's amazing how many cool ideas you'll have when you're supposed to be clearing your mind.

[ricksegalCanada]

This was super helpful and, after six years, relevant and very much appreciated!
Thank you

[SixMinutesSmarter]

I teach Office applications and Web Development at a community college in Oregon. I'm self-taught in Office apps. Had to learn on the job after college when I worked for an insurance company (I've got a Business/Finance background). Later, in '97, I started learning HTML to make web pages.

Thanks for watching.

[InfinityShakes]

Thank you. Helped me with my assignment for class.

[TheBrilliantPhoenix]

Ralph has a very good voice for instruction! Unfortunately, the Office version is several generations past, and Access has changed significantly in the meantime.

[momalade]

Thank you so very much.  Just what I was looking for.  You are awesome!!!!

[salmashaik]

thank you mate u helped me with my exams

[danishharoon]

Thank u have my IGCSE finals tommorow alot of help

[kerrieleong]

Thank you Ralph. Very interesting tutorial.

[lamunugloria]

Thanks a lot, when do formulas come in use and which ones are the only recommended signs / or formula ones to be used?

[smmng]

I am very new to access and in the process of making a database - thanks - helped a lot

[nicoled]

Can you suggest on how I would create a querie and report in Access of all employee work schedules for the week? I was hoping to make the report look like a table with the days of the week across the top/columns and hour increments along the left side/rows and all the employees scheduled for those times and days are in the table's center. Thank you!

[goodgirlteccie]

How do I display values of a field in a query? I tested and i never got that one because it didnt make sense to me

[yash]

i think this will help me too.... (was preparing query for marks wise distribution of topics, grouped according to unit they belong to).

[sinisterem]

Hi, useful video. I have a bit of a noob-question: how do I create a field that calculates the sum total of a column?
Goal is to have query from wich I can create a two column report: colomn a: expanses, column b: amount. And one field with the sum total of all the expenses.

[slyowusu]

question. what is the best way to create an Annual leave booking simple DB on Access 2003? For a few staff members to ensure we all do not take leave at the same time. thanks