Lessons

Important Notice

There is a glaring error in video 1 at time index 3:18 (and in the intro slide for the video) where I show you a sample SQL statement. I can't believe I let this error even get into the video. I actually have the SQL statement in the slide wrong. The WHERE clause needs to go before the ORDER BY clause. Stupid mistake. I must have been running low on coffee that day. The statement should correctly read:

SELECT * FROM CustomerT WHERE State="NY" ORDER BY LastName

Great mistake to have in a video that's supposed to "introduce you to SQL for the first time," eh? Alex has been bugging me to fix this for years, so I'm putting a note here. I'll be re-recording all of these videos soon.

Resources

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.

Comments for Access Expert 3

Age	Subject	From
2 months	Contact Subform SQL instead of query	Zachary Pritz
6 months	Contact Form	Lizelle Henrico
7 months	Printing Subform One Record	Sreerangan Bhaskaran
13 months	Locking content in notes	Stephen Hamer
2 years	Cleaning up SQL Statement	Benjamin Heacox
2 years	how to add a sign	Vannak Hou
2 years	Steps	Vannak Hou
2 years	Customer Combo	Patricia Tonge
2 years	why is there no logging of eac	Joseph Rosenfeld
2 years	Line Item Expand in Table	John Draper
2 years	product category form Lesson 4	John Hall
2 years	Using COUNT	Joan Young
2 years	Form CallbackF	Michael Munitz
2 years	Adding Subform to Customer For	Michael Munitz
2 years	Form footer totals	Sedef Iskit
3 years	Form Totals	Sandra Truax
3 years	Access Forms	Samantha Smith
3 years	SQL Error Message	Hendra Gunawan
3 years	Form Footer Totals 0 Units	Robert Lund
3 years	Lesson 3 Subforms	Robert Lund
Next >>

Subscribe to Access Expert 3
Get notifications when this page is updated