Project Detail

concatenate multiple child records into a single value

concatenate multiple child records into a single value is project number 274681
posted at GetAFreelancer.com. Click here to post your own project.

Status: Closed
(Project expired)

Selected Providers: -

Budget: $30-250

Created: 06/14/2008 at 18:19 EDT

Bid Count: 14

Average Bid: $ 42

06/19/2008 at 18:19 EDT

Project Creator: Mr2006
Employer Rating: 10.00/10 (1 reviews)

Description

I have a query made from 5 tables Events_tbl and activity_tbl. The relationship is one-many. on a monthly basis, I prepare a report for the month events. I want instead of having each traveler's name in one row, I want to be able to group all the travelers in few rows. to be clear, the report now is about 15-20 pages. because one trip may have 8 travelers or more. I want to reduce space andf paper. I want to have the names one after the other example:

Trip to Italy
Travelers:(John Smith, Steve James, Mark Edward)

Right now, it will show like this:
Trip to Italy

Travelers:
John Smith
Steve James
Mark Edward

Can this be done?

Thanks

Report Violation

Messages Posted: 1

If you are the project creator or one of the bidders Log In for more options

PMB

0 days

06-14-2008 20:41 EDT

9.88/10 9.88/10 9.88/10 9.88/10 9.88/10 9.88/10 9.88/10 9.88/10 9.88/10 9.88/10
(90 reviews)

easy work.

yugolancer

0 days

06-14-2008 18:32 EDT

9.68/10 9.68/10 9.68/10 9.68/10 9.68/10 9.68/10 9.68/10 9.68/10 9.68/10 9.68/10
(62 reviews)

Let me check how i can be of help. Show me the database structure and the report. See PM

Prashantskin

2 days

06-14-2008 21:44 EDT

9.87/10 9.87/10 9.87/10 9.87/10 9.87/10 9.87/10 9.87/10 9.87/10 9.87/10 9.87/10
(15 reviews)

Please see the PMB. I will do it within time.

KellogITSolution

0 days

06-16-2008 01:03 EDT

10.00/10
(9 reviews)

Hello Please check your PMB. Thanks

cheungkc

1 day

06-14-2008 23:16 EDT

10.00/10
(5 reviews)

Please check if sample file meets with your expection.

cooldev

2 days

06-18-2008 06:26 EDT

9.80/10 9.80/10 9.80/10 9.80/10 9.80/10 9.80/10 9.80/10 9.80/10 9.80/10 9.80/10
(5 reviews)

Yes this can be done with slight changes in the coding. We would need sample database (MS Access/MS SQL) and the existing code and reports.

nilusgupta

1 day

06-15-2008 00:02 EDT

(No Feedback Yet)

The Work is very easy.

programmerdelhi

100

2 days

06-15-2008 00:14 EDT

(No Feedback Yet)

Hi, Please check PMB

sameersac

1 day

06-15-2008 03:55 EDT

(No Feedback Yet)

We are expert in Microsoft Technologies and this can be easily done via VB (Subject to information/code or tables provided).

naveenv

100

1 day

06-15-2008 03:56 EDT

(No Feedback Yet)

you will be astonished with the result, we could discuss for more robustness, if you need

skumarnvcghd

2 days

06-15-2008 11:55 EDT

(No Feedback Yet)

I can do this easily. I have done many this type of projects.

dshobad

0 days

06-16-2008 03:37 EDT

(No Feedback Yet)

can be done.

mkasid

1 day

06-16-2008 04:06 EDT

(No Feedback Yet)

Yes, indeed this can be done. You will not regret giving me a chance.

amazher

1 day

06-16-2008 10:07 EDT

(No Feedback Yet)

No time required to fulfill this task

Bid on this Project

WHAT IS GETAFREELANCER.COM?

Get A Freelancer is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.