<div>
Hi lwadwell,<br />
<br />
Brilliant solution. Thank you.
</div>


Hi lwadwell,

Brilliant solution. Thank you.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Please Consider the following SQL Statement:<br />
<br />
sSQL = &quot;Select SalLevel, Count(Gender = 'Male') As MaleCnt, Count(Gender = 'Female') As FemCnt From Employees &nbsp;Group By SalLevel&quot;<br />
<br />
When I execute the above statement, I get the Grouping correct except that my <b>FemCnt </b>is Equal to my <b>MaleCnt</b>. And my MaleCnt is correct.<br />
<br />
Can somebody please detect what I am doing wrong.<br />
<br />
I am using VB.Net 2010 and running under Windows 7.<br />
<br />
Many thanks
</div>
</div>


Hi

Please Consider the following SQL Statement:

sSQL = "Select SalLevel, Count(Gender = 'Male') As MaleCnt, Count(Gender = 'Female') As FemCnt From Employees  Group By SalLevel"

When I execute the above statement, I get the Grouping correct except that my FemCnt is Equal to my MaleCnt. And my MaleCnt is correct.

Can somebody please detect what I am doing wrong.

I am using VB.Net 2010 and running under Windows 7.

Many thanks

More Than One Counter In SQL Statementt

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.