Queries Helpsheet-EN

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.