Re: Help somehow turn this into a single query

2001-09-06 Thread Carl Troein
Ken writes: > Query question: > > Can anyone think of a way to accomplish this in a single query?: > > I have a table with elements that each have a date. > For a given record, I want to get, in one query, the record just earlier than this >record's date, and the record just later than this r

Help somehow turn this into a single query

2001-09-06 Thread Ken
Query question: Can anyone think of a way to accomplish this in a single query?: I have a table with elements that each have a date. For a given record, I want to get, in one query, the record just earlier than this record's date, and the record just later than this record's date. I can easily