Query for portion of data

[RiverHorse]

Hello everyone,

My db has a field for e-mail addresses among many other fields. I need to create an Access query that will pull all data and sort it by the characters that appear after the "@" sign, basically ignoring everything before the "@" sign.

How can I do this?

Thanks in advance for any assistance with this.

Drew

 

[jebry]

Hi Drew!

In your query add this field:

NewfieldName: Mid([TableName]![EmailField],InStr([TableName]![EmailField])+1)

Sort by this field. Please note that you must substitute the appropriate names from your Db for TableName and EmailField, what you put in for NewfieldName is optional.

hth
Jeff Bridgham