Using flag fields


show more Using flag fields provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts show less
please wait ...

Using flag fields

This tip is less of an Access feature than it is a practical solution that will help your workflow. If you ever needed to run a report or a query that only includes specific records, but they vary each time. For example, may be I'm doing a series of promotions for my olive oils, but my selection of recipients isn't based on any of the criteria in my Customers Table, I need a way to mark who will be included. Flags are really nothing more than the Yes/No field. Open up your Customers Table and make sure you are clicked in Customer ID. I'll go to my Table tools Field's ribbon and I'll choose a Yes/ No field.

It enters a new field and now I will immediately type the name Flag and press Enter. Now click on the field name and then click it again and drag it before Customer ID, so it's the first field. The last step is to make the field only as big as the check box itself, so it doesn't take up a lot of room. Hold your cursor over the line between the fields. This mig...

Using flag fields
Video duration: 2m 1s 3h 43m Intermediate

Viewers:

Using flag fields provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Power Shortcuts

Subject:
Business
Software:
Access
Author:
please wait ...