My Assistant
Site Message
(Message will auto close in 2 seconds)
 Split Function, Office 2010
|
|
 Feb 23 2012, 10:31 AM
Post
#1
|
|
|
UtterAccess Guru Posts: 564 From: Miami, FL  |
Hi There,
I’m having a hard time figuring this out. What would be the equivalent of the following function in Access SQL? Split(table.field,”.”,1) I’ve search everywhere and noted Access doesn’t handle Split Function for SQL. Thanks (IMG:style_emoticons/default/thanks.gif) |
 |
 
|
Posts in this topic
ScorpDevil Split Function Feb 23 2012, 10:31 AM
Bob G there is a split function in Access. what is it th... Feb 23 2012, 10:38 AM ScorpDevil Hi Bob,
I know I can use Split with VBA, but cann... Feb 23 2012, 10:47 AM Bob G i would look at it this way if possible. is it alw... Feb 23 2012, 10:50 AM theDBguy Hi,
You can also create your own function that us... Feb 23 2012, 10:53 AM ScorpDevil Thanks Bob - II’ve try that already but no luck
I... Feb 23 2012, 11:23 AM Bob G here it is if you want it. modify the fields accor... Feb 23 2012, 11:26 AM Bob G yes, you can use your functions in a query. Feb 23 2012, 11:27 AM theDBguy Hi Scorp,
QUOTE (Bob G @ Feb 23 2012, 09... Feb 23 2012, 11:32 AM ScorpDevil Bob - Thanks it worked with your code. Thanks.
No... Feb 24 2012, 01:50 PM
Bob G i am sure DBG can explain better than I, but, here... Feb 24 2012, 02:14 PM |
  |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 22nd May 2013 - 11:55 PM |