From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create calculated fields and grouping within queries

Create calculated fields and grouping within queries

From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Start my 1-month free trial

Create calculated fields and grouping within queries

“

- [Instructor] There may be times when you need to perform calculations on the data in your tables but it really doesn't make sense to calculate the data directly in the table but what does make sense is to create a calculated field within a query. Once you've created your calculated field, you can then format the results in say, a currency style with two decimal places. In this video, I'm also going to show you how to group your records together. You can group your records by any of the fields within your table. Let's go ahead and look at our 04_06 Calculated_Fields_Grouping database. I have the Employee information table open and we see that the HOURLY RATE for each employee is included within this table. We're going to create a new query, and within that query, we'll create two calculated fields; one to calculate what a 3% increase in their HOURLY RATE would be and the second to calculate what a 5% increase in their HOURLY RATE would be. Let's go ahead and close the Employee…

Contents