General Question about Querys

J

Joe Cilinceon

Where is a good site for learning some of these query or SQL methods. In the
last few days I've asked for help with a couple of queries and have gotten
methods (that worked great) I have never seen anything on.
 
V

Van T. Dinh

All the syntax elements are in the Microsoft JET SQL Reference section of
Access Help.

A very good book on JET SQL is "SQL Queries for Mere Mortals" by Michael
Hernandez & John Viescas.
 
J

Joe Cilinceon

Thanks Van I'll check it out. I'm just now getting into the help section on
queries.
 
C

Chris2

Joe Cilinceon said:
Where is a good site for learning some of these query or SQL methods. In the
last few days I've asked for help with a couple of queries and have gotten
methods (that worked great) I have never seen anything on.
Click to expand...

Joe Cilinceon,

Websites:

http://www.mvps.org/access
http://allenbrowne.com/
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Articles


Books: General: Beginner

Database Design for Mere Mortals by Michael J. Hernandez

SQL Queries for Mere Mortals by Michael J. Hernandez, John L.
Viescas


Books: General: Intermediate/Advanced

Advanced SQL Programming, For Smarties, 3rd Edition, by Joe Celko

SQL Puzzles and Answers, by Joe Celko



Books: Access : Intermediate

Access Cookbook by Getz, Litwin, and Baron
(Compilation of solutions, listed by task-category)


Books: Access: Advanced

Building Microsoft Access Applications, by John L. Viescas

Access Database Design & Programming by Steven Roman (2nd or 3rd
Edition)

Access Developer's Handbook (for your version of Access)


Sincerely,

Chris O.
 
J

Joe Cilinceon

Thanks Chris very helpful.
Joe Cilinceon,

Websites:

http://www.mvps.org/access
http://allenbrowne.com/
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Articles


Books: General: Beginner

Database Design for Mere Mortals by Michael J. Hernandez

SQL Queries for Mere Mortals by Michael J. Hernandez, John L.
Viescas


Books: General: Intermediate/Advanced

Advanced SQL Programming, For Smarties, 3rd Edition, by Joe Celko

SQL Puzzles and Answers, by Joe Celko



Books: Access : Intermediate

Access Cookbook by Getz, Litwin, and Baron
(Compilation of solutions, listed by task-category)


Books: Access: Advanced

Building Microsoft Access Applications, by John L. Viescas

Access Database Design & Programming by Steven Roman (2nd or 3rd
Edition)

Access Developer's Handbook (for your version of Access)


Sincerely,

Chris O.
Click to expand...
 
Top