![]() ![]() Change the Return box to the number of records you wantĪ join query is a query that contains data from multiple tables, those tables are all inter-connected through various relationships.The user would type in an employee number such as EJ and click OKĪccess would only display the records for employee number EJĪ top value query is a query that sorts your fields from ascending to descending. The program will then prompt the user to enter the Employee number when it is run and the following Pop-up will be displayed. To set up this query you will need to type into the criteria field. This is very useful if a help desk person needs to access the records of a client each time they call to look up information quickly. This query will list all the companies that are on Main Street OR paid more than $100.00Ī parameter query is one that lets the user answer the question each time it is run to get to the records that they want. If you move one of the query criteria down one row to the OR field you create an OR Criteria. Here we are querying companies that are on Main Street and paid more than $100.00 You can fill in multiple criteria from one column to the next and this will take on an AND relationship. If you had employees Tom and Tim and wanted to list all of their clients you could do this by typing in T?M into the criteria field.ĪND Criteria Query The asterisk replaces a group of characters. A question mark replaces one character only. You can also use a question mark for a wildcard. Then when you run the query you get the results: If you wanted to find a client whose name began with B you could do a query for B* like below. You use a wildcard to fill in for characters that you don't know. The query will return only the records with an employee number of BOKE. ![]() Click the exclamation point for RUN at the top.Go to the Criteria for the Client Number and type in BOKE.Use the drop downs at the top of each column to sort, or limit the data. What client names begin with "M" and has paid more than $100.00?.What clients belong to a certain employee?.What clients have paid more than $100.00?.What clients are located on Main Street?.Lesson What is a Query Ī query is a way of asking the database some questions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |