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 ...

Get Microsoft Access 2013 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.