Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-30-2019, 09:49 AM   #16
kolait
Newly Registered User
 
Join Date: Oct 2019
Posts: 38
Thanks: 8
Thanked 0 Times in 0 Posts
kolait is on a distinguished road
Re: split field

Quote:
Originally Posted by isladogs View Post
So do we all. But I have good news for you
See https://www.devhut.net/2018/04/22/ac...it-in-a-query/
I tried this but it made an error

kolait is offline   Reply With Quote
Old 10-30-2019, 09:50 AM   #17
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,728
Thanks: 57
Thanked 1,260 Times in 1,241 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: split field

Quote:
Originally Posted by kolait View Post
thank you so much..
It was great..
Hi. You're welcome. We were all happy to assist. Good luck with your project.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
kolait (10-30-2019)
Old 10-30-2019, 10:49 AM   #18
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,951
Thanks: 114
Thanked 2,993 Times in 2,721 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: split field

Quote:
Originally Posted by kolait View Post
I tried this but it made an error
It does work. Perhaps you used it incorrectly.
Even though you have a solution, I would recommend trying it again as it is so useful.
If you still get an error please provide details / screenshots

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 10-30-2019, 02:50 PM   #19
kolait
Newly Registered User
 
Join Date: Oct 2019
Posts: 38
Thanks: 8
Thanked 0 Times in 0 Posts
kolait is on a distinguished road
Re: split field

Quote:
Originally Posted by isladogs View Post
It does work. Perhaps you used it incorrectly.
Even though you have a solution, I would recommend trying it again as it is so useful.
If you still get an error please provide details / screenshots
thank you
I managed to do it.
You and many other friends have helped me a lot. Thank you all
kolait is offline   Reply With Quote
Old 10-31-2019, 07:04 PM   #20
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,728
Thanks: 57
Thanked 1,260 Times in 1,241 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: split field

I usually point people to this one. It does the same thing.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Split a field jnh Tables 3 01-02-2012 01:08 AM
Split name field krazykasper Crystal Reports 1 01-27-2009 05:39 AM
split one field into two Mike Hughes Queries 4 12-28-2007 05:46 AM
Split field value into two Poppy Queries 2 02-28-2005 05:38 AM
Split a Field GetReel Forms 2 01-29-2004 02:40 PM




All times are GMT -8. The time now is 08:24 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World