On 23 Oct 00, at 22:38, Russell Jones wrote:
> First off, I'm using Access 2000...
>
> I need this query to get all messages in a thread except the first message
> that started it. What I have clearly does not work. I seems like it should,
> but it doesn't.
Check out Access' TOP predicate (instead of ALL as in your example). It allows
you to return only the number of records specified from the top of the return
set. By negating it, you can return everything EXCEPT that number of records.
Assuming your originating message is first in the recordset, this should take
care of the problem.
- Jeff
==============================================================
| Jeffrey S. Peters | "Specialization is for insects." |
| [EMAIL PROTECTED] | - Lazarus Long |
==============================================================
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
