Recent content by DenItech

Hmmm... You think in order to accomplish this i need to write a pragram with if statements? I thought there was a simpler way to do this. Anyone else have any suggestions?

I have already tried this. This query list duplicate record of the clients name with the multiple telephone numbers. I want the the name and phone numbers to be on the same record. ex: (name, phone1, phone2, phone3, phone4) thanx for the reply

I have 2 tables which is a one-to-many relationship. In the first table it has the name of clients. On the second table it has multiple phone numbers of that certain client. The table is link by a nameid in both table. How can i get those information into one table. With the format (Client's...

I have a question that seems kinda easy. I want to get data from 2 tables where there is a 1 to many relationship. The first table consist of the person name, The second table has 4 of his phone number in it. How can I combine The two table so that it will have this (name ,1st phone number, 2nd...