March 1, 2021
Hot Topics:

Visual Basic Database Tutorial - Part 3

  • By Karl Moore
  • Send Email »
  • More Articles »

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

This article was originally published on November 20, 2002

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date