How do you make a report with more than 15 fields?

[mastermithi]

I've got a database with almost 35 fields. When creating a report directly, only the first 15 fields show up. How do I create a report such that every field is included in it?

 

[CJ_London]

by database I presume you mean table

they should all show - just check that the missing ones are not on pages 2/3/4. You many need to adjust field sizes/spacing so they all fit on one page

 

[strive4peace]

hi @mastermithi

the wizard is limited. To get more controls containing fields, you need to modify what the wizard creates -- or just make a custom report to begin with

 

[strive4peace]

ps, @mastermithi, adding on

Here are a couple videos about Access reports that might be helpful for you:

Create a Grouped Report using the Wizard in Access, then Modify it

Polish Reports in Microsoft Access

 

[Gasman]

I've got a database with almost 35 fields. When creating a report directly, only the first 15 fields show up. How do I create a report such that every field is included in it?

I have just added all 26 from Customers extended query in the Northwind DB, using the wizard?
Of course a good few are on the second page even in landscape.

Did you use the >> button?

 

[mastermithi]

hi @mastermithi

the wizard is limited. To get more controls containing fields, you need to modify what the wizard creates -- or just make a custom report to begin with

I just used the normal create report option because i just need a simple one.

 

[strive4peace]

the report designer is like the form designer, so if you can modify forms, you can modify reports the same way