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

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 422,818 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,304 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser: Programming Forums

Thread Tools Display Modes

Views: 2076 | Replies: 0

•

Join Date: Oct 2006

Posts: 4

Reputation: jclast is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

jclast

Offline

Newbie Poster

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

Nov 10th, 2006

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!

Help with Code Tags

(Toggle Plain Text)

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;