Forum Discussion

Clayton_cramer's avatar
Clayton_cramer
Copper Contributor
Jan 26, 2021
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....
2013
access
  • Gustav_Brock's avatar
    Gustav_Brock
    Feb 04, 2021

    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's avatar
Clayton_cramer
Copper Contributor
Feb 02, 2021

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.
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Feb 02, 2021

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.

Resources