Use a 2nd Query for Complex Calculations or Criteria

In this Microsoft Access tutorial, I will show you how to use a secondary query for criteria and complex calculations. You'll learn about string concatenation, using the Left function, creating customer codes, and handling query criteria. Perfect for beginners but useful for all skill levels!

Prerequisites

• Concatenation
• Calculated Fields
• Query Criteria
• Parameter Query
• String Functions

Links

• Enter Parameter Value

Recommended Courses

• Access Beginner 1

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, query criteria, complicated calculations, string concatenation, calculated field, parameter query, query design, customer code, shipping code, query-calculated field, Access functions, left function, concatenate values, creating queries, second query, query troubleshooting, data type mismatch, lookup query