Hi,

I think this would require a query, I have a database containing one table which actually only uses column A as it is an email address list.

What I am trying to do is just seperate the .co.uk email addresses from the rest either by a query that just shows the .co.uk addresses or maybe some more elorate method?

Does anyone have any ideas?

Regards,

Graeme

Hi,
welcome to UA forums.
sure you can use a query if you want...put this in the criteria:

Like "*.co.uk"

Or make a new expression which pulls the right e.g.:

Expression1: Right([YourField],6)
Then use criteria:

".co.uk"

HTH
Good luck

Thanks for the quick reply, you guys really know your stuff here.

I can see me spending my days on here from now on!!

Thanks again for all the help

Graeme

You're welcome.
Good luck on future projects!