One quick question. I fell pretty good about Access. Seem like it holds your hand. I am building queries in design view and looking at the SQL code. Access seems really redundant.
Here is the query I made in design view
I am watching training videos on Lynda about just SQL
SELECT tbl_ClassList.[CLASS NAME], tbl_ClassList.DAY, tbl_ClassList.TIME
WHERE (((tbl_ClassList.[CLASS ID])=4));
it was written this way.
It seems so much easier to list the rows and then cite the table. Thanks for all you help. I am going to keep watching videos and hopefully it will click sooner than later : )
Select [CLASS NAME], [DAY], [TIME] FROM tbl_ClassList WHERE DAY='mon';
This stuff is really fun.