Tweet
Modify that query using "Design View" in Microsoft Access.
1. From Datasheet View, switch to Design View by clicking on the Design View icon (from the tool bar): Modifying a query - step 1
(If you can't see this icon, select "Design View" from the "View" menu). You should now see something like this:
The top panel shows us the tables that are used in this query (we only use one table in our query). The bottom panel is where we specify what to do with each field in the table. We can nominate to display a field or not display it. We can sort the results by any of these fields. We can also provide criteria to be used in filtering the results. We'll do this in the next step.
2.In the "Criteria" cell for the "FirstName", add the word "Homer". While you're there, add the IndividualId field so that it will also be displayed in our results. Do this by selecting "IndividualId" from the dropdown menu on the third column. Also, ensure that the "Show" checkbox is checked:
Now when you switch back to Datasheet for watching the result.
1. From Datasheet View, switch to Design View by clicking on the Design View icon (from the tool bar): Modifying a query - step 1
(If you can't see this icon, select "Design View" from the "View" menu). You should now see something like this:
The top panel shows us the tables that are used in this query (we only use one table in our query). The bottom panel is where we specify what to do with each field in the table. We can nominate to display a field or not display it. We can sort the results by any of these fields. We can also provide criteria to be used in filtering the results. We'll do this in the next step.
2.In the "Criteria" cell for the "FirstName", add the word "Homer". While you're there, add the IndividualId field so that it will also be displayed in our results. Do this by selecting "IndividualId" from the dropdown menu on the third column. Also, ensure that the "Show" checkbox is checked:
Now when you switch back to Datasheet for watching the result.