This is not really a VBA item, but it’s important and you will need to understand this concept when you are creating your SQL statements in VBA.
In our example we have a table called “Customers”:
Now we just want the customers from “London”. So we set up a select query to select just the customers in “London”.
Here are the steps:
Now our result just shows customers in London
Let me know if you have any questions.