Query work in Access Query, but don't work in C#

[nta_3886]

My database Access have 3-columns : ID (int), Doc_no(string), Rcv_date(Date). I try to filter the newest row in the rows that have same Doc_no. i have a query for database Access :

SELECT ID, Doc_No, Rcv_Date,
FROM [SDC Documents Record] A
WHERE (ID =
(SELECT TOP 1 ID
FROM [SDC Documents Record]
WHERE (A.Doc_No = Doc_No)
ORDER BY Rcv_Date DESC))

That query still work well with Query Tool in Access, but in Query Builder in Visual Stuido 12 - C#, there are message : "Error in WHERE clause near 'ORDER'" . I don't know why. Plesea help me to fix it

leo

[Mycroft Holmes]

The ( puts the ORDER BY inside your WHERE clause, you have 2x ( and 3x )

Never underestimate the power of human stupidity RAH

[Bernhard Hiller]

SELECT ID, Doc_No, Rcv_Date, FROM

the last comma is wrong - but with it, the query should not run in MS Access either.