SELECT count(*) as 'ax mass murders'
WHERE (incidents.ax=1);
Access rejects this as "The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect."
Missing "FROM incidents"
The count seems too low.
Trying to sum dead by decade was hard but I solved it:
select int(year/10)*10, sum(incidents.dead) as dead from incidents group by (int (year/10)*10);
I don't work with Access much but usually if you have a table or field name that would conflict with a keyword you can surround it with []. Thus, if I remember correctly, you could have a field named, say, select, by calling it [select] instead.
ReplyDelete