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

Closed Posted Sep 26, 2015 Paid on delivery
Closed Paid on delivery

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 Software Architecture SQL Visual Basic

Project ID: #8556833

About the project

30 proposals Remote project Active Nov 6, 2015

30 freelancers are bidding on average $31 for this job

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 in 1 day
(335 Reviews)
7.1
zExcel

A proposal has not yet been provided

$100 USD in 1 day
(134 Reviews)
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 More

$29 USD in 1 day
(87 Reviews)
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 More

$30 USD in 0 days
(140 Reviews)
6.2
gkalish

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

$35 USD in 1 day
(227 Reviews)
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 More

$30 USD in 3 days
(88 Reviews)
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 in 1 day
(31 Reviews)
5.4
axiomswb

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

$25 USD in 1 day
(26 Reviews)
5.2
Khurramz

Will it be okay if I submit in excel? .

$15 USD in 1 day
(19 Reviews)
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 in 1 day
(26 Reviews)
4.4
zkutch

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

$25 USD in 1 day
(14 Reviews)
4.3
BhargavaB

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

$25 USD in 1 day
(18 Reviews)
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 in 1 day
(10 Reviews)
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, More

$35 USD in 2 days
(2 Reviews)
2.6
alizsardi

A proposal has not yet been provided

$15 USD in 1 day
(1 Review)
0.8
idlirbekteshi1

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
MohammedAdnanT

A proposal has not yet been provided

$23 USD in 1 day
(0 Reviews)
0.0
shasz123

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
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 More

$25 USD in 1 day
(0 Reviews)
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 More

$25 USD in 1 day
(0 Reviews)
0.0