Cant' figure out where my syntax error is (Access query)

[jclast]

Hey all, I'm using Access in conjunction with C# and ASP.net 2.0. I can't get the following query to work in Access, and I have no idea why it's throwing a syntax error. Any help would be appreciated. Thanks!

SELECT a.name, a.origDate, b.firstName, b.lastName, c.priority
FROM afmMain AS a
INNER JOIN afmUsers AS b ON a.origID = b.id
INNER JOIN afmPriorities AS c ON a.priorityID = c.id
WHERE a.archived = no
ORDER BY a.priorityID ASC, b.lastName ASC, b.firstNameASC;