<div>
It says: syntax error (missing operator) in query expression
</div>


It says: syntax error (missing operator) in query expression

<div>
the query that posted for MS sql server, Sorry i can't help you in Access 2007
</div>


the query that posted for MS sql server, Sorry i can't help you in Access 2007

<div>
<div class="content wysiwyg-content">
Hello, how can I subtract 23 from sum(tblCountData.Incount) only if the value is greater than 0?<br />
<br />
SELECT tblCountData.RecDate, sum(tblCountData.Incount) AS trafficcount<br />
FROM tblCountData<br />
GROUP BY tblCountData.RecDate;
</div>
</div>


Hello, how can I subtract 23 from sum(tblCountData.Incount) only if the value is greater than 0?

SELECT tblCountData.RecDate, sum(tblCountData.Incount) AS trafficcount
FROM tblCountData
GROUP BY tblCountData.RecDate;

SQL Select statement question

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.