Thanx John
Its working
Thanx a lot
Regards
You mesh
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, May 27, 2011 8:52 PM
Subject: RE: [MS_AccessPros] RE: Help to find query for..
Yes, please? Did that answer your question?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of You mesh
Sent: Friday, May 27, 2011 3:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] RE: Help to find query for..
Yes Please
Regards
You mesh
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, May 27, 2011 6:34 PM
Subject: [MS_AccessPros] RE: Help to find query for..
You mesh-
You cannot attach anything to a message posted to the group. You must put any file you want to share in the Files / Assistance Needed section of the group website.
But since you sent me a copy directly, I can give you an answer:
SELECT * FROM Table1
WHERE Table1.[visit date] =
(SELECT Max([visit date]) FROM Table1 As T2
WHERE T2.[emp id] = Table1.[emp id])
You can turn that into an INSERT or Make Table query to put the selected rows into another table.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
<http://www.viescas.com/> http://www.viescas.com/
(Paris, France)
From: You mesh [mailto:matkarumesh@yahoo.com]
Sent: Friday, May 27, 2011 2:52 PM
To: MS_Access_Professionals@yahoogroups.com; john@viescas.com
Subject: Help to find query for..
Dear all
Please help to collect unique data from so many duplicate data but want to select latest date wise different table.. i am giving here snap shot of those data
pls find attached jpg image
Regards
You mesh
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar