Search results for query: *

Thanks Jeff and in the orginal database its not events i just typed it that way to give an example of what my issue was. The orginal table as over 25000 records and it only has one event per column. Thanks for all the feed back im going to give that a try Jeff and see how it works...

Thanks I will do that I just was not aware that is what everyone ends up doing. Thought there might have been an easy way to fix the report view but I changed my reports to default to print preview

Little more specific I would like to the Report View option to insert page breaks in the report. Right now it only does new pages if i use print preview. The report view option just stretches the page further and further down depending on how many records are there.

Is there a way to start a new page without being layout view and forcing a new page. for instance be able to tell the report to start a new page after so many records or do i have to manually do it? I am using MS Access 2007

Thanks again for the replies it is some good reading I will mess with this stuff some more because i was trying to put myself in a situation like I ran across a badly programed table and had to restructure it and it had over 20000 records. Trying to learn more thats all.

Appreciate the response but with a crosstab layout I think you would have dropdown list instead of it auto populating I will read more up on crosstab layouts thanks again

I have a table with 2 columns AccountID Events 111111 Movies 111111 Concert 111111 Basketball 222222 movies 333333 basketball 222222 football 111111 concert 222222 movies 333333 sports Basically something...