UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Is there any way to seperate .co.uk email addresses??    
 
   
gsmcellular
post Jul 19 2006, 11:59 AM
Post #1

New Member
Posts: 13
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
Go to the top of the page
 
+
 
 Start new topic
Replies (1 - 3)
freakazeud
post Jul 19 2006, 12:07 PM
Post #2

UtterAccess VIP
Posts: 31,413
From: NC, USA
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
Go to the top of the page
 
+
gsmcellular
post Jul 19 2006, 12:24 PM
Post #3

New Member
Posts: 13
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
Go to the top of the page
 
+
freakazeud
post Jul 19 2006, 12:25 PM
Post #4

UtterAccess VIP
Posts: 31,413
From: NC, USA
You're welcome. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)
Good luck on future projects!
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 05:31 AM