How to display a dynamic crosstab query

[laffeg]

help !

I have designed a database for a sales team to record orders taken etc

they currently have a whiteboard where they mark up orders taken for each day - they want to replace this with a large monitor and display the info automatically from the database.

I have created 2 crosstab queries and associated reports that refresh every 5 seconds. what i cant figure out is how to display them - either 2 report windows open at the same time or on a form so that i can have one report under the other. It needs to be automated so that when the application opens the reports show on startup

any help appreciated !

 

[the_net_2.0]

what about one report and a subreport? I'm sure you can treat a subreport as it's own, with no related fields between the two. I suppose all you'd need is a source object, if that...right?

either that, or could you have two rpt's open at the same time? each window half the size of the monitor?

 

[laffeg]

thanks

got it working using a form with subforms rather than reports

found that reports in access 2010 can have an On Timer event procedure but not access 2003