Help Please with Select Statement using AND
(already answered in gettingstarted)
Please do not multi-post.
If you think it is necessary for your question to appear in more than one
newsgroups (it rarely is), use cross-posting (sending only ONE post with up
to 3 relevant newsgroup addresses on the post).
--
HTH
Van T. Dinh
MVP (Access)
Quote:
> This is probably ridiculously easy but I can't figure or
> find any examples
> of how to use "AND" here is my example
> Set rst = dbs.OpenRecordset("select count(*) from
> [memberstable] where
> [active]=true AND where [clubId] = me!clubId")
> I've tried & and other variations but just can't figure
> it. So any help
> would be definately appreciated.
> Thanks
> Sharon B
