Add a field to a query using the QBE grid

If you are using more than one table in your query, click in the Table row of the first blank column and, from the drop-down list that appears, select a table.You must have added the table to the query for it to appear in the Table list.

Click in the Field cell in the same column, above the table you selected in step 1. From the drop-down list that appears, select a field.The asterisk (*) indicates all fields from the selected table. This can be useful if you want to display all fields in your query’s dynaset: select the asterisk and you don’t have to add each field manually to the QBE grid. However, if you want to sort, filter, or perform calculations, you will still need to add the appropriate fields to the QBE grid individually.