Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Queries > Help with retur...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 41242 of 43104
Post > Topic >>

Help with returning the newest record in a query

by =?Utf-8?B?SmVzc00=?= <JessM@[EMAIL PROTECTED] > Aug 8, 2008 at 07:52 AM

I have a form that comments can be entered into and receive a time stamp.
So 
I end up with multiple comments per project number. I want to run a query 
that only returns the newest comment. Below is what I tried, but it is
only 
returning the most new comment and not the newest comment by project
number.

SELECT Data_ProjectComments.Project_Number, 
Data_ProjectComments.CurrentTime, Data_ProjectComments.CommentCode, 
Data_ProjectComments.Comment
FROM Data_ProjectComments
WHERE (((Data_ProjectComments.CurrentTime)=(SELECT MAX(CurrentTime) FROM 
Data_ProjectComments)));
 




 4 Posts in Topic:
Help with returning the newest record in a query
=?Utf-8?B?SmVzc00=?= <  2008-08-08 07:52:01 
RE: Help with returning the newest record in a query
=?Utf-8?B?YWtwaGlkZWx0?=   2008-08-08 09:32:01 
RE: Help with returning the newest record in a query
=?Utf-8?B?SmVzc00=?= <  2008-08-08 10:25:00 
Re: Help with returning the newest record in a query
John Spencer <spencer@  2008-08-08 16:30:52 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Nov 20 21:31:46 CST 2008.