Ditutup

concatenate multiple child records into a single value

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

Kemahiran: Visual Basic

Lihat lebih lanjut: mark may, be smith, concatenate child records, trip report, steve, steve s, smith, italy like, concatenate, visual basis, prepare, reduce, child relationship, group basis, will prepare, mr2006, multiple will, visual relationship, multiple pages, query visual basic, clear visual, multiple tables, want records, row visual basic, visual basic rows

Tentang Majikan:
( 8 ulasan ) ASAA, United States

ID Projek: #274681

14 pekerja bebas membida secara purata $42 untuk pekerjaan ini

yugolancer

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

$51 USD dalam 0 hari
(10 Ulasan)
6.0
Prashantskin

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

$30 USD dalam 2 hari
(128 Ulasan)
5.7
KellogITSolution

Hello Please check your PMB. Thanks

$30 USD dalam 0 hari
(12 Ulasan)
4.3
cheungkc

Please check if sample file meets with your expection.

$30 USD dalam sehari
(6 Ulasan)
3.0
wincent

easy work.

$30 USD dalam 0 hari
(1 Ulasan)
2.0
cooldev

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.

$40 USD dalam 2 hari
(1 Ulasan)
1.2
sameersac

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

$30 USD dalam sehari
(1 Ulasan)
1.0
nilusgupta

The Work is very easy.

$30 USD dalam sehari
(0 Ulasan)
0.0
programmerdelhi

Hi, Please check PMB

$100 USD dalam 2 hari
(0 Ulasan)
0.0
naveenv

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

$100 USD dalam sehari
(0 Ulasan)
0.0
skumarnvcghd

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

$30 USD dalam 2 hari
(0 Ulasan)
0.0
dshobad

can be done.

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

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

$30 USD dalam sehari
(0 Ulasan)
0.0
amazher

No time required to fulfill this task

$30 USD dalam sehari
(0 Ulasan)
0.0