Microsoft Access Queries

If you wish to know the basics on how to create a query, then I suggest you download my free tutorial. This does not only include how to create a query in Microsoft Access, but will step you through the entire process of building your first database in MS Access. To learn the basics of Microsoft Access then:

Click Here

I am currently revamping this site, and transferring all the query related tips, questions and answer links to this page, from this page:

Simply Access Tips Index

So if you are sure there should be something here that isn't, check out the Index page above, or contact me on my 'Contact Page' to put forward your suggestion and I will do my best to include it.

Nested IIF Statements

Using a Nested IIF Statement in a query.

This tip explains how to add a Nested IIf Statement to a query, but you can also adapt this tip to learn how to use one in an unbound text box on a form or a report.

Too Many Nested IIFs Required

If you need TOO Many nested IIFs then click here

If you have two many nested IIFs, i.e. more than 7 or if it is just getting too messy, then a bit of code maybe necessary, to keep everything succinct, this tip will step you through how to achieve this in queries.

Excluding Values

Trying to work your way around Excluding Values in a query then click here

Most people know how to include values in a Query but what about Excluding Values? These two examples will give you some insight.

Append Query

Append Query

This tip will step you through how to build an Append Query.

Counting Checked Check Boxes in a Query

Counting Check Boxes Query

Having trouble counting how many check boxes are checked in a query? Then this tip should help.

Multiple Criteria in an Update Query

Multiple Criteria in an Update Query

This tip will explain how to use a Nested IIF statement to handle multiple criteria in an update query.

Adding Time fields

Adding time fields in a query

This tip will explain how to add to separate time fields in a query, form and report. Specifically if the result is going to be greater than 24 hours.

It also explains how to sum a time field in a continuous form or in a report.

Finished with Microsoft Access Queries, then return to Simply Access Home Page