How to combine test item in one row ms report

[dazai]

Good Day mam/sir

I have a simple question from a noob.

I just want to make a summary report of a patient with several test request in a one row.

On my form i have a header like Patient Name, Examination Request etc. i want to make this in single row per patient.

Please see my attached image.



Thanks in advance and more power.

[ranman256]

This is not how a database works, however,
you can make a Crosstab query to VIEW the data your way.

use the query wizard to build the query with output you want to see.
add a button or tab control to your form to view either the current (editable) version,
or the Crosstab version.

[dazai]

Sorry sir i think i have a mistake on my question. i mean on report i want to combine the test request like on my sample image.

same id and did on the same day and time.



is this posible? thanks for your time guys.

this is my sample Form

[pbaldy]

How about:

http://allenbrowne.com/func-concat.html

[dazai]

How about:

http://allenbrowne.com/func-concat.html

thanks sir i will try this and give you feedback.

[pbaldy]

No problem, and welcome to the site by the way.