Forum Discussion
Solved
Inserting empty rows
This should be simple, but my SQL skills are rusty. I have a query that extracts the year and a count of incidents from a table. SELECT year, Count(year) AS incidents FROM Table2 WHERE ((Table2....
Clayton_cramer If you don't like IIF, then use IN:
SELECT year, Abs(Sum([cause_ID] In (15, 16))) AS incidents FROM Table2 GROUP BY year;
Clayton_cramer If you can, I would like some sample data to work with in order to see what might the problem is. Thanks.
BTW. Access most definitely will evaluate the expression once it is properly written, so please include your query with that expression with the sample data. Thanks.
George_HepworthI tried attaching the database:
Correct the highlighted errors and try again.
- The attachment's massmurder.accdb content type (application/msaccess) does not match its file extension and has been removed.
Clayton_cramer If you can, compress it into a ZIP file and see if that will upload. If not, we can try an alternate method.