ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Recent Posts
Chinese motors rated 220 v 50 hertz
by gfretwell - 07/23/24 04:45 PM
100 Definitions: Accessible 2023
by gfretwell - 07/23/24 10:12 AM
100 Definitions, Likely to Become Energized, 2023
by gfretwell - 07/23/24 10:08 AM
240V only in a home and NEC?
by emolatur - 07/18/24 01:05 PM
2023 CEU Course
by gfretwell - 07/17/24 01:08 AM
Advertisement:-Left
Recent Gallery Topics:
This is a new one
This is a new one
by timmp, September 24
Few pics I found
Few pics I found
by timmp, August 15
Who's Online Now
1 members (Scott35), 882 guests, and 27 robots.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate Thread
#132072 02/20/05 04:25 AM
Joined: May 2004
Posts: 364
G
Gloria Offline OP
Member
Hello!

I'm having problems with using access or sql. Can anyone help me?

1., I want to put together two coloumns. In excel I'd do it with concatenate. In access? There are some built-in functions, but I dunno which one to use. (It is not a solution to do it in excel, while the base datas can change and I have to run this update query some times.

2., How to choose a row of numbers from a database if I don't know, how long the number is?
This case it is telephone numbers, which cal be 1 - 7-8 long. How to look it up?

Thank you in advance,

Gloria


The world is full of beauty if the heart is full of love
Horizontal Ad
#132073 02/20/05 12:51 PM
Joined: Dec 2002
Posts: 228
J
Member
Gloria, you can concatenate in SQL with the 'concat' command

eg 'Insert into table1.field3 concat(table1.field1+table1.field2)'

I think that would work for you, but the concat is the concatenate command for SQL.

As far as the query for the phone number how is it structured? Is each number in its own column and you need to select non-null values?

'select * from table1 where column<>'0''

#132074 02/21/05 02:34 AM
Joined: May 2004
Posts: 364
G
Gloria Offline OP
Member
Hello!

Thank you, I'll try.
The problem with the phone numbers is that I don't know, how long it is.
The best would be if I could enter 2-3-4-5, any numbers and it would recognize the location, I mean in the databases there are country and local numbers. For ex. 18007654321 and if I type 18007 it would recognize the 1800 which is in the list.


The world is full of beauty if the heart is full of love
#132075 02/21/05 02:40 AM
Joined: May 2004
Posts: 364
G
Gloria Offline OP
Member
Dear JCooper!

Sorry, It was not working in access. [Linked Image]
I thought I had to make an update query, cause the base data table can change.

Any advise?


The world is full of beauty if the heart is full of love
#132076 02/23/05 11:44 AM
Joined: May 2004
Posts: 364
G
Gloria Offline OP
Member
I visited the ms online forum for help and that is -I must say - a very good site. there are very skilled people helping.

I can suggest to use it.


The world is full of beauty if the heart is full of love

Link Copied to Clipboard
Advertisement:-Right

* * * * * * *
Tools for Electricians
Tools for Electricians
 
* * * * * * *

2023 National Electrical Code (NEC)
2023 NEC + Exam Prep Study Guides Now Available!

Member Spotlight
togol
togol
NW In. USA
Posts: 421
Joined: September 2005
Top Posters(30 Days)
Popular Topics(Views)
323,674 Are you busy
247,972 Re: Forum
231,750 Need opinion
New Page 2
Powered by UBB.threads™ PHP Forum Software 7.7.5