Report and horizontal/row wise (1 Viewer)

DevAccess · Oct 26, 2016

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 · Oct 26, 2016

have you considered using a crosstab query?

Uncle Gizmo · Oct 26, 2016

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

Sent from my SM-G925F using Tapatalk

DevAccess · Oct 26, 2016

CJ_London said:
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 · Oct 26, 2016

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 · Oct 26, 2016

CJ_London said:
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 · Oct 26, 2016

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.

Report and horizontal/row wise (1 Viewer)

DevAccess

Registered User.

CJ_London

Super Moderator

Uncle Gizmo

Nifty Access Guy

DevAccess

Registered User.

CJ_London

Super Moderator

DevAccess

Registered User.

Minty

AWF VIP

Similar threads

Users who are viewing this thread