Lukket

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

Færdigheder: Visual Basic

Se mere: mark may, be smith, concatenate multiple child records single value, 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

Om arbejdsgiveren:
( 8 bedømmelser ) ASAA, United States

Projekt-ID: #274681

14 freelancere byder i gennemsnit $42 for dette job

yugolancer

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

$51 USD in 0 dage
(10 bedømmelser)
6.0
Prashantskin

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

$30 USD in 2 dage
(128 bedømmelser)
5.7
KellogITSolution

Hello Please check your PMB. Thanks

$30 USD in 0 dage
(12 bedømmelser)
4.3
cheungkc

Please check if sample file meets with your expection.

$30 USD på 1 dag
(6 bedømmelser)
3.0
wincent

easy work.

$30 USD in 0 dage
(1 bedømmelse)
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 in 2 dage
(1 bedømmelse)
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 på 1 dag
(1 bedømmelse)
1.0
nilusgupta

The Work is very easy.

$30 USD på 1 dag
(0 bedømmelser)
0.0
programmerdelhi

Hi, Please check PMB

$100 USD in 2 dage
(0 bedømmelser)
0.0
naveenv

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

$100 USD på 1 dag
(0 bedømmelser)
0.0
skumarnvcghd

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

$30 USD in 2 dage
(0 bedømmelser)
0.0
dshobad

can be done.

$30 USD in 0 dage
(0 bedømmelser)
0.0
mkasid

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

$30 USD på 1 dag
(0 bedømmelser)
0.0
amazher

No time required to fulfill this task

$30 USD på 1 dag
(0 bedømmelser)
0.0