Front and back report

[jamccarley]

I need to add a training matrix on the back of a report. Can access do a
report with two sides?

Josh McCarley

 

[Larry Linson]

I need to add a training matrix on the back of
a report. Can access do a report with two sides?

Two-sided printing is a system and/or printer function, not a database
function.

 

[a a r o n . k e m p f]

Nope, that is too much data for Jet.

Better move to SQL Server and Reporting Services (unless you _LIKE_
doing all your database calculations _TWICE_ for everything you do)

 

[Larry Linson]

Mr. Kempf's answer has, as is usually the case, nothing to do with the
poster's question.

Larry Linson
Microsoft Office Access MVP

 

[BruceM]

It has the added disadvantage of almost certainly being incorrect,
especially considering he has no idea about the amount of data.

 

[a a r o n . k e m p f]

Technically; any Access (jet) implementation that _I've_ ever seen--
starts to take _FOREVER_ when you get reports that are more than a
single page.

Thus-- Jet can't handle that much data (to fill up two pages)

 

[BruceM]

Then it is a design problem, because I have reports with hundreds or even
thousands of records that load in less than a second, even with subreports.

message
Technically; any Access (jet) implementation that _I've_ ever seen--
starts to take _FOREVER_ when you get reports that are more than a
single page.

Thus-- Jet can't handle that much data (to fill up two pages)

 

[a a r o n . k e m p f]

wow, that's great-- is that why Microsoft states that ADP reporting is
consistently faster for all scenarios?
wow, that's great-- is that why Microsoft states that ADP reporting is
consistently faster for all scenarios?
wow, that's great-- is that why Microsoft states that ADP reporting is
consistently faster for all scenarios?
wow, that's great-- is that why Microsoft states that ADP reporting is
consistently faster for all scenarios?
wow, that's great-- is that why Microsoft states that ADP reporting is
consistently faster for all scenarios?

 

[BruceM]

What is it with you and repetition?

message
wow, that's great-- is that why Microsoft states that ADP reporting is
consistently faster for all scenarios?
wow, that's great-- is that why Microsoft states that ADP reporting is
consistently faster for all scenarios?
wow, that's great-- is that why Microsoft states that ADP reporting is
consistently faster for all scenarios?
wow, that's great-- is that why Microsoft states that ADP reporting is
consistently faster for all scenarios?
wow, that's great-- is that why Microsoft states that ADP reporting is
consistently faster for all scenarios?

 

[a a r o n . k e m p f]

you're the dirty hairy mother fucker that follows me around and warns
everyone else that I don't know what I'm talking about.
meanwhile, you can't even spell SQL, kid.

So why don't you ask yourself 'Why does Bruce need to chase around
Aaron and warn everyone about him-- even though Aaron is a certified
DBA (and Bruce is not) Bruce somehow thinks that Bruce knows more
about SQL_AND_ACCESS_AND_VB than Aaron.

Grow some balls, kid-- learn a real database

-Aaron