Sorting

[marigona]

i need to help me about sorting the area on form , example on the area name i have : Antonio Brajan Cristian Digi Erio Lebron John ... and i need to sort them from "E" to "Z" and after Z to stick those names that start with "A" to "D". pls help me

[marigona]

noone cant reply this ???? i need for tonight pls

[orange]

A quick thought, for names beginning A-D, prefix them with "ZZZ", UNTESTED
then sort the file ascending,
then write the data to a table,
Read the table, changing any name beginning ZZZ to Mid( yourname, 3)

[marigona]

thnx but i cant do it because the teacher want to tell him with pc , not to cheat

[orange]

So this is homework. Have you talked to your friends?

My thoughts were just thoughts, not cheating. Try it yourself.

[marigona]

ok big thnx

[June7]

No need to modify data and write to another table.

Create a field in query that calculates a value for sorting using orange's idea of the ZZZ prefix. Use that field in the sorting criteria.

SELECT * FROM tablename ORDER BY IIf(Left([namefield],1) LIKE "[A-D]", "ZZZ", "") & [namefield];

[marigona]

thnx but i dont know how to do it if u can explain with photo would be great

[June7]

This is basic Access functionality. Use the query builder. Can switch to SQL view. Copy/paste the suggested SQL statement and change [tablename] and [fieldname] to your actual names. Switch back to Design view to see the structure.

Use the query as the form RecordSource.