How Do You Select Multiple Items For An Access Query?
Access is a Microsoft technology database program. It’s used in desktop-type workplace environments, and files also can be used in simple web applications. It can even be used as an interface with massive-scale web applications. Access allows you to manage large amounts of data, such as customer lists, and query and sort that data. Using multiple items in a query works the same way in all of these applications. This “how-to” covers Microsoft Access 2002. The concepts are the same, though, throughout the versions. Open the Access database in Access. Select the table you want to work with by highlighting it and double-clicking on it. The table will open up on your screen. Take a look at the fields that may be appropriate for your query. Close the table and choose the “Queries” object. Select “Create query by using a wizard.” The wizard will ask you which fields you’d like in your query. There will be a list of the available fields or the “multiple items,” as the title of this article ref
