Updating multiple fields in access

by  |  05-Feb-2018 17:51

Most of them live within the city limits, but others live out of town or even out of state.

We want to get our out-of-town customers who've placed orders in the past to come back and give us another try, so we're going to mail them some coupons.

Updating multiple fields in access

Each record of an order identifies the customer who placed that order.

If we include the order ID numbers, we should be able to narrow our list down to only customers who have previously placed orders.

Throughout this tutorial, we will be using a sample database.

If you would like to follow along, you'll need to download our Access 2013 sample database.

To write queries, you'll need to be able to set criteria in a language that Access understands.

Community Discussion