Serial Number Horizontally viewing.

[Suresh_Murugan]

Please advice. How to make Serial no Horizontally view in report.

Example: 1 2 3 4 5 6 7 8

 

[Ranman256]

create a crosstab query.
use the query wizard.

 

[Suresh_Murugan]

create a crosstab query.
use the query wizard.

Hi Ranman256. Thanks for your reply. But I want different. I attached sample database for your reference. Please advise

 

[JHB]

Open the report in design view, choose from the menuline/ribbon:
"Page Setup"->"Columns"

 

[Suresh_Murugan]

Open the report in design view, choose from the menuline/ribbon:
"Page Setup"->"Columns"

Thanks for your reply. It's working.

 

[JHB]

You're welcome, good luck.