User Profile
Collapse
Profile Sidebar
Collapse
kr85
Last Activity: Apr 14 '13, 01:31 AM
Joined: Feb 12 '13
Location:
-
Thanks so much bud ur da man...God bless you -
-
-
[z{original post#14 }]
yes i need it when it execute that query it will take all emails data from contact field and display them in a new field name email then i need it also to pull all mail addresses in a new field name address.
[z{original post#15 }]
right now my table of customer contact is like this:
...Code:CustomerName Contact Rico 34 Mills Avenue
Last edited by zmbd; Mar 4 '13, 02:42 AM. Reason: [Z{once again... 4 posts covering the exact same information. This isn't a "Twitter" account - Please use some thought before posting}{added code tags for table formatting}]Leave a comment:
-
[Z{Edit - Original Post #4}]
Thanks seth..
We are very close...
again il explain..
I have a field called contact it has either email adress or street adreeses.
When i run my query i need to tell it put all email address in 1 other field called email and all the street address in another field name address.
So the contact field has either an email or street addrees?
[z{Edit - Original Post #5}]...Leave a comment:
-
How to split content of data in 1 field into 2 fields
I have to run a query in access sql or using query wizard to split the data of field into 2.
The field has data such as 1234 ave willie and has email adresses sucha haha@yahoo.com .I need to create put 1234 ave willie in a new field name St address and haha@yahoo.com in email field.Can some help?
should as wildcard such as like operator etc?
No activity results to display
Show More
Leave a comment: