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

Counting with and comparative list

P: n/a
Okay, I have a query that generates a list of ClientID's that I want
included in a count. Take a look at the following query and make any
changes that you see fit to make it operational.

SELECT [CR - tbl Client Record, More Information].MaritalStatusID,
Count([CR - tbl Client Record, More Information].MaritalStatusID) AS
CountOfMaritalStatusID
FROM [CR - tbl Client Record, More Information]
GROUP BY [CR - tbl Client Record, More Information].MaritalStatusID
HAVING MaritalStatusID <> null AND
([CR - tbl Client Record, More Information].ClientID IN
(SELECT [STS - ApplicableClients].ClientID FROM [STS - ApplicableClients])
);

Thanks!

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Chad Reid <te***@cyberdelia.homeunix.org> wrote in message news:<Pi************************************@cyber delia.homeunix.org>...
Okay, I have a query that generates a list of ClientID's that I want
included in a count. Take a look at the following query and make any
changes that you see fit to make it operational.

SELECT [CR - tbl Client Record, More Information].MaritalStatusID,
Count([CR - tbl Client Record, More Information].MaritalStatusID) AS
CountOfMaritalStatusID
FROM [CR - tbl Client Record, More Information]
GROUP BY [CR - tbl Client Record, More Information].MaritalStatusID
HAVING MaritalStatusID <> null AND
([CR - tbl Client Record, More Information].ClientID IN
(SELECT [STS - ApplicableClients].ClientID FROM [STS - ApplicableClients])
);

Thanks!


How about inner joining your list of clientIDs to this list and then
doing the count on that?
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.