<div>
Something like the following should work. &nbsp;BTW, you should not use [Date] as a field name in Access because it is a reserved name and must have brackets around it to represent the field (it conflicts with the Date() function).<br />
<br />
SELECT Sum(iif(Format([Date]), &quot;mmyy&quot;) = [YourDate], 1, 0) as MonthCount,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sum(iif(Format([Date]), &quot;yy&quot;) = Right([YourDate], 2), 1, 0) as YearCount<br />
FROM YourTable
</div>


Something like the following should work.  BTW, you should not use [Date] as a field name in Access because it is a reserved name and must have brackets around it to represent the field (it conflicts with the Date() function).

SELECT Sum(iif(Format([Date]), "mmyy") = [YourDate], 1, 0) as MonthCount,
             Sum(iif(Format([Date]), "yy") = Right([YourDate], 2), 1, 0) as YearCount
FROM YourTable

<div>
Hi Fyed,<br />
<br />
Its giving me an error function has wrong number of arguments.<br />

<pre><code id="code-20-39570667-1">SELECT Sum(iif(Format([ Decision Date]), &quot;mmyy&quot;) = [YourDate], 1, 0) as MonthCount,
             Sum(iif(Format([Decision Date]), &quot;yy&quot;) = Right([YourDate], 2), 1, 0) as YearCount
FROM Application
where status = 3;</code></pre>
</div>


Hi Fyed,

Its giving me an error function has wrong number of arguments.


SELECT Sum(iif(Format([ Decision Date]), "mmyy") = [YourDate], 1, 0) as MonthCount,
             Sum(iif(Format([Decision Date]), "yy") = Right([YourDate], 2), 1, 0) as YearCount
FROM Application
where status = 3;

<div>
<div class="content wysiwyg-content">
Hi Guys<br />
<br />
I am trying to write a query which can provide me Monthly Total depends on the user input date and year to date total also in the same query.<br />
<br />
My table has the fields : Application Id, Status, Date.<br />
<br />
My query should give an out put<br />
<br />
Total Record In Oct-13 &nbsp;= 10<br />
YTD Record &nbsp;Till Oct-13 = &nbsp;50 (will Add all from Jan-13 -Oct-13)
</div>
</div>


Hi Guys

I am trying to write a query which can provide me Monthly Total depends on the user input date and year to date total also in the same query.

My table has the fields : Application Id, Status, Date.

My query should give an out put

Total Record In Oct-13  = 10
YTD Record  Till Oct-13 =  50 (will Add all from Jan-13 -Oct-13)

Access Query

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

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.