Any recommendations for books that cover SQL programming for Access?
I've already posted a question regarding Access's syntax for compound
join statements (many-to-many using Link tables), but I'm hoping there
is a good book that covers this type of thing.

"_DS" <_DS@__nomail.com> wrote
[color=blue]
> Any recommendations for books that cover SQL programming for Access?
> I've already posted a question regarding Access's syntax for compound
> join statements (many-to-many using Link tables), but I'm hoping there
> is a good book that covers this type of thing.[/color]

There's a sponsored newsgroup specifically for Queries, which deals with
both the Query Builder and with SQL -- microsoft.public.access.queries,
accessible through the free news server news.microsoft.com, or through an
online user interface you'll find at http://office.microsoft.com.

I don't know of a book that is limited to Access' Queries / SQL, but
browsing in a well-stocked bookstore would give you an idea of which have
more coverage.

Larry Linson
Microsoft Access MVP

i asked that question myself awhile back; here's a recommendation i got:

SQL Queries for Mere Mortals, by Michael Hernandez and John Viescas
http://www.amazon.com/gp/product/020...books&v=glance

hth


"_DS" <_DS@__nomail.com> wrote in message
news:ukdnv1ti2rk51bjit9f92ing9oa2d8s07s@4ax.com...[color=blue]
> Any recommendations for books that cover SQL programming for Access?
> I've already posted a question regarding Access's syntax for compound
> join statements (many-to-many using Link tables), but I'm hoping there
> is a good book that covers this type of thing.[/color]