dcsimg
June 17, 2018
Hot Topics:

Visual Basic Database Tutorial - Part 3

  • November 19, 2002
  • 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



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 


Enterprise Development Update

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

By submitting your information, you agree that developer.com may send you developer offers via email, phone and text message, as well as email offers about other products and services that developer believes may be of interest to you. developer will process your information in accordance with the Quinstreet Privacy Policy.

Sitemap

×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date