By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,105 Members | 1,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,105 IT Pros & Developers. It's quick & easy.

Book recommendation for access queries?

P: n/a
Greetings,

I am migrating Access queries, is there a book that people recommend,
ideally with close to EBNF (concise) SQL Query description

Is the 'Access 2003 Bible' a good choice, or should I just rely on
msdn?

Thank you for your time,

Turloch O'Tierney

Background:
10 Years Oracle programming including Oracle SQL, PL/SQL + Microsoft
SQLServer SQL and T/SQL, but a novice to MS Access.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
since you obviously must know how to write queries yourself, you could
just create a bunch of queries of various types (various joins,
inserts, updates, deletes...) with the QBE and then just print out the
query name and SQL. You could slap up some code to do it in a few
seconds...

Something like... (not tested... this is off the top of my flat
head)...

Public Sub PrintQueryDefs()
dim db as dao.database
dim qdf as dao.querydef

set db=currentdb
for each qdf in db.Querydefs
'---don't want control rowsource queries showing up
if left(qdf.name,1)<>"~" then
debug.print "==============="
debug.print qdf.name
debug.print "---------------------------"
debug.print qdf.SQL
end if
next qdf
set db=nothing
end sub

Then if you use some reasonable names for your queries, you'll get a
reasonable output that you can try to make sense of.

Since you know Oracle a lot better than I, I'll leave you to read a few
query SQLs and learn for yourself. I wouldn't be pointing out anything
that's anything other than blatantly obvious anyway...

Hope this helps, though.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.