O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building a query on a query

When you’re building a very complex query, sometimes it’s easier to visualize the solution to the problem at hand by breaking it down into smaller pieces. In some cases, building a query on a query might be the only way to correctly solve the problem. So far, you’ve created a totals query that calculates the total number of hours and tips for active restaurant employees. You’ve also used the Coalesce function to display a zero value instead of Null for any case where the employee has no hours or tips. We can create another query that builds on the foundation of this totals query to calculate regular and overtime wages for the employees.

Start a new query, click the Queries tab in the Show Table dialog box, select the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required