Follow the steps that will help you to create a query and a report.
Queries
1. To create a query, go to the Create tab and then click on Query Design.
![]() |
![]() |
||
2. Select the table or tables that you
want to search by selecting them and clicking Add and then Close
the window
3. Select all the field names in the table by clicking on the top word FanID (not the *), holding shift on the keyboard and then clicking the bottom field, in this case Email. This will highlight them all orange. (you will need to repeat this step and step 4)
4.
Click where it is orange and drag it down into the first
box at the bottom. This will put all the fields in the query design at the
bottom.
5.
To search for something type it under the field you
are searching under on the criteria row. Here you can tick the
information you'd like to see and untick the irrelevant information.
6.
To add some sorting click in the sort row under
the field you want to order it under and select Ascending (A-Z) or descending
(Z-A)
7.
8.
To find your results click on the red exclamation mark
called Run and it will show you your results.
The results will look like something similar to this:
Save your query by clicking the save
disc in the top left hand corner and give your query a name.
Материалы на данной страницы взяты из открытых источников либо размещены пользователем в соответствии с договором-офертой сайта. Вы можете сообщить о нарушении.