Sorting Text Field by Sections divided by a dash

[Trish]

Can you sort text fields where sections are divided by a dash (-)



RESTRICT TO GATE -DEFECT - UAT Restrict to gate : User able to restrict a flight prior to 30 min and 45 min departure time

Write query to pull by DEFECT in the text above??

[rzw0wr]

Can you sort text fields where sections are divided by a dash (-)

I think you can. The problem I see is when you try to sort a Text field with more than 1 word it would take a very long time.
I think Access will only sort by the first word.

RESTRICT TO GATE -DEFECT - UAT Restrict to gate : User able to restrict a flight prior to 30 min and 45 min departure time

I am confused here. Is this an example of what you want to sort?

Write query to pull by DEFECT in the text above??

I think this is doable.

in the query enter ="Defect"

Dale

[pbaldy]

I suspect what you want is to sort on whatever is after the dash. If so, check out the Mid() and InStr() functions.