Ditutup

Access Database Query

I have one table which has multiple contacts listed on each row for the same companies. I need a way to take the list and convert it from showing several contacts for each company on several rows to columns next to the company.

The attached excel file gives an example. Sheet one is the original table/list and sheet two shows the result. You will see in sheet two that there is one company listed per line with the contacts listed as first first_2, first_3, etc.

You can use the web address as the unique identifier.

I need a query for this that I can use in access for a table with these specific columns.

I need this as soon as possible.

Kemahiran: Pengaturcaraan C, Memasang Skrip

Lihat lebih lanjut: n query, i need an access database, query merge multiple columns column access database, php count access query, access query convert multiple records across columns, access database search contact per company, php query data access database, web query access database, access data query form, query table, line sheet, Convert Database, companies database, C# access, c access, access, access c#, excel convert access, excel access table, access query table, access query excel, database example, database sheet, multiple database, access table query

Tentang Majikan:
( 149 ulasan ) Thousand Oaks, United States

ID Projek: #335623

15 pekerja bebas membida secara purata $47 untuk pekerjaan ini

rajtuhin1

Master in .NET and having vast experience in Excel data reformat. Select me ASAP. You will get results within 4 hours. Thanks.-TUHIN

$30 USD dalam 0 hari
(30 Ulasan)
6.4
simonchen

hi, dear sir: i'm serious. pls check P.M.B , thanks.

$30 USD dalam 0 hari
(34 Ulasan)
6.1
tonmay

It should be a very easy work for me. Waiting for your selection to proceed on. Thanks, Tonmay

$30 USD dalam sehari
(40 Ulasan)
6.1
HussienSharaf

HI, i made similar tasks like this one. plz check PM thanks

$120 USD dalam 2 hari
(13 Ulasan)
4.8
cnut17

this could be done via the cross analysis function if there was only one contact info to dispatch or if they could be merged in one cell. to get exactly this layout, a little VBA code has to be written. what if y Lagi

$50 USD dalam 3 hari
(3 Ulasan)
4.0
LexelDesigns

Please see PM for further details.

$100 USD dalam sehari
(1 Ulasan)
3.4
VisionsUnleashed

Please check PMB for details. Thank you.

$50 USD dalam sehari
(1 Ulasan)
2.8
dataconsultants

Please check PMB for details, Thank you

$35 USD dalam sehari
(3 Ulasan)
2.4
wenzor

I need possible amount of records in actual data file.

$30 USD dalam sehari
(0 Ulasan)
0.0
d187

Hello, I'm interested in your project!

$30 USD dalam 5 hari
(0 Ulasan)
0.0
divamL

I'll do it!

$30 USD dalam 0 hari
(0 Ulasan)
0.0
mnash0915

I can do this for you quickly and easily. I would be happy to help. Thanks!

$50 USD dalam sehari
(0 Ulasan)
0.0
PACCESS

I can do this give me a shot!

$50 USD dalam sehari
(0 Ulasan)
0.0
RFORD29

Hi, I could do this very quickly I am looking for experience on how this site works. I could write teh SQL query so that you just past it into your database run it and all your problems are solved. Dont think th low Lagi

$30 USD dalam sehari
(0 Ulasan)
0.0
SimonH77

I'm an MSAccess systems developer with over 10 years experience in developing complex MSaccess systems for blue chip companies and have previously written a facility within MSAccess (using VBA) to merge multiple rows i Lagi

$35 USD dalam 2 hari
(0 Ulasan)
0.0