Query assistance

I am trying to pull some "notes" from a sql database....the notes that
are put into the database come via the web and the user is entering it
for a certain task. they are stored in their own table and field and
get assigned and incremental ID #.

I want to be able to pull up the latest entry to the task, not all of
the notes just the latest one.. The entry does get a timestamp in the
field so I am thinking I might be able to look at that field
somehow... Right now my query shows all notes / entries for the task.

I am an intermediate sql query guy so I hopefully expained enough to
get assistance.

Let me know if you need to know more.Here is the sample data...
iwmsjn_Note iwmsjn_Timestamp
working on SQL queries for reports2/17/2006 4:20:34 PM
Researching a report for Sheri 2/28/2006 4:35:21 PM
Working on Reports / Queries 3/3/2006 3:34:04 PM
Test Delete 3/8/2006 1:45:30 PM

I only want the one that says "Test Delete" stamped for TODAY...not
the others.|||This should do it...

selectiwmsjn_Note
from[tablename] a
whereiwmsjn_Timestamp = (select max(iwmsjn_Timestamp)
from [tablename] b
where a.[ID] = b.[ID])

Jody

Query and textbox difficulty.

Can anyone help please? On a login page i have constructed, u can login (if ur registered) by entering your surname and postcode. Once logged in i would like a welcome note to display the Customer_Name on the Customer homepage. If i use the following statement would it find the items in the specified text boxes and print the correct name?

RsCUSTOMER.open "Select Customer_Name from CUSTOMER WHERE Customer_Surname = the value in the text box AND Customer_PostCode = the value in the text box", Conn

<%Response.write("Welcome" & rsCUSTOMER("Customer_Name")%>

Any help would be much appreciated.
Regards, JohnYou should get the customer name based on your query, though you might want to make sure that the surname and postal code is a unique combination or you'll end up with more than 1 result