ive created this Cross/pivot table in access.. and now i want to show the results in a report..
sometimes i have quite alot of columns (65 believe it or not
) so i cant put it in a report cos it will try to put all the collumns on one page
is their a way to set a limit of how many columns u want per page? othertwise im gonna try doing it with recordsets in vba, but this must have happened b4 rite?
help would be greatly appreciated
sometimes i have quite alot of columns (65 believe it or not
) so i cant put it in a report cos it will try to put all the collumns on one page is their a way to set a limit of how many columns u want per page? othertwise im gonna try doing it with recordsets in vba, but this must have happened b4 rite?
help would be greatly appreciated