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

who did made a program that is like Pain(simple,it only draw line,rectangular...) in Windown.if you made,you can share for me.I am making it,but it is dificult

leo

i find a program as program PAIN in Window.if you have ,please share for me

leo

i make a software help to connect many device with PC,use COM1 in PC.it sent a syntax(have adrees of receiver),and after a little time the device(receiver) sent data to PC in COM1 my problem is if it ask all device,and wait the answer all device,it used many time.that is bad I want it work multitasking-it ask a device,and when it wait for answer,it can ask other device... note:COM1 only can sent or receive at the moment

leo

thank your reply.my problem:i make a event draw a line example Point p=new Point(); Pen pe =new Pen(Color.Black,1); private void mouseDown (object sender, MouseEventArgs e) { p = e.Location; } private void mouseUp(object sender, MouseEventArgs e) { Graphics g = this.CreateGraphics(); g.DrawLine(pe,p,e.Location); g.Dispose(); } this code draw a line from the location at Mouse Down to the location at the Mouse Up When mouse move, I want alway have a line from location at Mouse Down to the location of Mouse at the moment.but when Mouse up,there is only a line. It is similar to the draw a line in program Paint of Window.i can't write code. If you know,please tell me quick

leo

I am writing code about a form.it similar to Paint of Window.i have a some problem,so i find code to look for my problem

leo

i have a mathematical function,example x^2+sin(x),but it is String.i want it is mathematical function,it can return value float

leo