Concatenate Column Values from Multiple Rows into a Single Column with Access

Cerrado Publicado Sep 26, 2015 Pagado a la entrega
Cerrado Pagado a la entrega

I have 1 table in database which has some values in different columns.

Based on invoice number I need to merge data to single row

to explain in simple words for example if row 1 invoice number is 101 which says description "shirts" and row 2 invoice is same that is 101 which says description "pants" than this all has to be merge like desc1, desc2 rate1 rate 2 in new table

Likewise there are 25 fields x 50 rows = 1250 new entries which will be created everytime when report will be generated.

Finally this has to be exported in excel.

Fairly it's easy and many documentations are avaialble, example are with code sample

[url removed, login to view]

My access version is 2007

Microsoft Access Microsoft Office Arquitectura de software SQL Visual Basic

Nº del proyecto: #8556833

Sobre el proyecto

30 propuestas Proyecto remoto Activo Nov 6, 2015

30 freelancers están ofertando un promedio de $31 por este trabajo

cgullapalli

Hi, I am good at macro. I would like to work on this project. Plz provide me the tables to work on this.

$35 USD en 1 día
(335 comentarios)
7.1
zExcel

A proposal has not yet been provided

$100 USD en 1 día
(134 comentarios)
7.2
fabest

Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you c Más

$29 USD en 1 día
(87 comentarios)
7.3
mail2vimalarora

Hi, I have gone through your project details and would like to take an opportunity to work on it. I have worked on several Access database projects and can help you on he solution. Waiting for your response on the Más

$30 USD en 0 días
(140 comentarios)
6.2
gkalish

Having 8 + years experience in MS Access and willing to start the work imediately .

$35 USD en 1 día
(227 comentarios)
6.3
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Wai Más

$30 USD en 3 días
(88 comentarios)
5.9
Grunty

Hi, I've got extensive experience in VBA with Access and Excel. I'm ready to start with your project, as soon as you open chat with me. Looking forward to your contact, Grunty.

$20 USD en 1 día
(31 comentarios)
5.4
axiomswb

I have expertise in this area.. I have gone through your proposal.. I can solve your problem.. thank you..

$25 USD en 1 día
(26 comentarios)
5.2
Khurramz

Will it be okay if I submit in excel? .

$15 USD en 1 día
(19 comentarios)
4.9
surekash7096

I have the expertise in Excel and can create an effective script t achieve the task description to concatenate column values

$25 USD en 1 día
(26 comentarios)
4.4
zkutch

Hello. More 20 years programming experience. I need more details to set real time and price. Regards. ---------------------------------------------------------------------------------------------------------------- Más

$25 USD en 1 día
(14 comentarios)
4.3
BhargavaB

Hi this is bhargava expert in mysql . i am ready to provide quick and efficient solution . Thanks Bhargava

$25 USD en 1 día
(18 comentarios)
3.8
ENRICOJ

HI. THIS SEEMS LIKE A FAIRLY EASY PROJECT. PLEASE FEEL FREE TO APPROACH ME FOR FURTHER ASSISTANCE. KIND REGARDS,ENRICO =====================================================

$25 USD en 1 día
(10 comentarios)
3.4
mohamadserag

I'm a Python dev, so if you awarded me the project I'm gonna use Python. I'm pretty good with desktop apps, and database design, and I think we need to discuss your table, It doesn't seem like a fine database design, Más

$35 USD en 2 días
(2 comentarios)
2.6
alizsardi

A proposal has not yet been provided

$15 USD en 1 día
(1 comentario)
0.8
idlirbekteshi1

A proposal has not yet been provided

$25 USD en 1 día
(0 comentarios)
0.0
MohammedAdnanT

A proposal has not yet been provided

$23 USD en 1 día
(0 comentarios)
0.0
shasz123

A proposal has not yet been provided

$20 USD en 1 día
(0 comentarios)
0.0
RV28

Dear Employer, I can perfectly do yours project work along with my dedication and able to complete full work in a shortest possible of time with 100% accuracy and perfection. Let's discuss in PM so that we can start wo Más

$25 USD en 1 día
(0 comentarios)
0.0
fittm

I am a fast and accurate typist and data entry specialist. With a background in computer end user training, I have an advanced knowledge of MS Word, Excel, PowerPoint and Outlook. I have also created my own training Más

$25 USD en 1 día
(0 comentarios)
0.0