Hello,

I'm trying to sort on the first char in a field. The first char is a "D" or a "H" or a "I" or a "O" . So the field contains
D1 till D999 or H1 till H999 and so on.
I made four queries with the Left$([fieldname];1)="D" and changed the "D" to "H".
How can I made this more simple.
The user must get a question to type the required letter? (Now it is done by a submenu)

could you please help me?

I'm confused. Sorting on the entire field will sort on the first character in that field. There's no need to worry about Left.

Do you mean that you want to limit what's displayed, so that you only see those records that start with D, or those records that start with H?

Put a critieria of

LIKE [What Letter?] & "*"

under the field. When the query's run, an input box will prompt the user for the letter they want.

Thanx,

Sorry that I confused you. It was exactly wat I mend (a limited display).
I was thinking to complicated with expr: and didnot use the LIKE correctly.

Thanx, problem solved!

Jan