Report and horizontal/row wise

[DevAccess]

Hello

I would like to create an access reports that has to be horizontal instead of vertical column wise field mapping to report query.

for example if 5 records for person it should give me five reports row/horizontally not column wise /vertical.

While putting existing fields from query on the report I wanted to put them as horizontal.

What would be best solution, please advise.

 

[CJ_London]

have you considered using a crosstab query?

 

[Uncle Gizmo]

Try this link:-
http://www.access-programmers.co.uk/forums/showpost.php?p=308045&postcount=2

Sent from my SM-G925F using Tapatalk

 

[DevAccess]

have you considered using a crosstab query?

In My report it shows as follow.

First Name
las Name
Class
Rank
Address
Street

It should be shown as follows

First Name --> Last Name --> Class --> Rank --> Address--> Street.
data 1 ........
data2..........

like was I dont know if cross tab query can help here
instead of showing column vertically I want to show them as horizontal.

 

[CJ_London]

I'm now confused. Are

First Name
las Name
Class
Rank
Address
Street

separate fields? in which case you can layout your report as you wish
one field? in which you can replace the carriage return with a space
one column of 6 records? in which case a crosstab would work providing you have some identifier in your record to indicate whether that record is a first name, last name etc

 

[DevAccess]

I'm now confused. Are

First Name
las Name
Class
Rank
Address
Street

separate fields? in which case you can layout your report as you wish
one field? in which you can replace the carriage return with a space
one column of 6 records? in which case a crosstab would work providing you have some identifier in your record to indicate whether that record is a first name, last name etc

is there anyway we can put report directly on form ? instead we create a button and that would open report ?

 

[Minty]

You can open a report that looks like a form, you just can't edit the data.
If it's just to look at, reports can be more flexible to look at, as textboxes can grow to accommodate different heights.