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.
I am embarrassed to say that I cannot figure out how to export my database with just a few records in it, so it is a size that I can upload.