jadeIT
Systems Analyst
- Local time
- Today, 17:52
- Joined
- Jul 16, 2002
- Messages
- 50
Hi,
I was wondering if it is possible to filter the results of a query by selecting one record, then only showing records that preceed it alphabetically.
So if you have these names in a database:
ALBERT
BOB
CARLA
DILBERT
EDWARD
FRED
And you choose to filter results from CARLA to EDWARD you would get the results
CARLA
DILBERT
EDWARD
I was wondering if it is possible to filter the results of a query by selecting one record, then only showing records that preceed it alphabetically.
So if you have these names in a database:
ALBERT
BOB
CARLA
DILBERT
EDWARD
FRED
And you choose to filter results from CARLA to EDWARD you would get the results
CARLA
DILBERT
EDWARD