[AccessD] Crosstab Report

Mark A Matte markamatte at hotmail.com
Wed Nov 7 13:43:44 CST 2007


Hi Barb,

It sounds like your 15th column is the same record as your first 14...can you put a page break in the middle of a record?

Could you move your 15th(or more) columns off the page to the right...forcing a new page when printed or viewed?

Thanks,

Mark A. Matte

> From: BarbaraRyan at cox.net
> To: AccessD at databaseadvisors.com
> Date: Wed, 7 Nov 2007 12:50:13 -0500
> Subject: [AccessD] Crosstab Report
>
> I have created a crosstab report which contains 14 columns of data. If the underlying crosstab query yields more than 14 columns, I want to add a new page to display the remaining columns. The data on the report is populated via code using a recordset based on the crosstab query.
>
> I am currently reading through the recordset and populating 14 columns of data, then doing a page break, an "rs.Movefirst", then reading thru the recordset extracting data beginning in the 15th column. However, the Detail Format and Print events do not fire.
>
> What am I missing?
>
> Thanks,
> Barb Ryan
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare!
http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hotmailnews



More information about the AccessD mailing list