Filtering results Alphabetically

[jadeIT]

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

 

[ColinEssex]

In the query you can use parameters.

Between [FirstName] and [SecondName]

The results will give you the names from name1 to name2

Col

 

[jadeIT]

thanks that makes things a lot easier. i had never heard of 'between' before.