help with query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi can anyone help me with a query

I have a table with a date field looks like

Date Name
200403 John
200403 Sally
200403 Dave
200404 John
200404 Sally
200404 Dave
200404 Steve

How can I select all records excluding the new record
added - ie steve.

So I would like to return
Date Name
200403 John
200403 Sally
200403 Dave
200404 John
200404 Sally
200404 Dave

as my recordset, by passinging in 2 dates 200403 and 200404


TIA
 
I don't see any difference between

200404 John
200404 Sally
200404 Dave
200404 Steve

other than the name Steve. After this record is added to the database,
it is no different than Dave or Sally. If you need to be able to
distinguish it from those, it will need to have a field that, say,
records the time it was added. I am trying to say that it is not obvious
the Steve is a new record. It may help to think about the data as
unordered bucket of information. The only way to fish something out is
to provide criteria for it.
Pavel
 
Back
Top