Visual Basic Database Tutorial - Part 3
To return all the fields in a table, we can double click on the asterisk in the Customer table, like so:
This tells Access you want to return every field (*) from the table. You could then perhaps add criteria to the query, like this:
The SQL statement for this query is:
SELECT Customers.* FROM Customers WHERE (((Customers.CompanyName)="Lazy K Kountry Store"));
OK, enough babbling about Structured Query Language - if you're interested in how Access can help you design queries that count records, sum field values and so on, press F1 whilst designing your query to launch the help.
Go on, press it! I promise I won't tell anyone. Except perhaps my Uncle Bob. And his wife. And his wife's personal assistant. And his wife's personal assistant's pet snail, Strangely Brown. And his wife's personal assistant's pet snail's in-house lover, Also Curiously Brown.
On a related note, try looking up the "=Date()" function and using it as criteria in a query.
Page 5 of 10