In part 1, I explained the worklfow and planning on how to create an Access query by taking a pen and paper exercise to create that checklist. In this second part, I’m going to quickly step you through the essentials. As a reminder, here’s the pseudo statement that started the process to list your tables, fields and other key attributes including criteria and sorting: Show a list of order transactions for the first quarter of 2011 of all customers based […]

Tags: create an access query, how to create a query, microsoft access query builder, query in ms access, setting criteria in queries