[AccessD] Reports

What sort of time would I expect when moving from Page 1 to Page 500 in a
report. i.e cliecking to go to the last page??

Fairly complex report which is pulling data from SQL Server using a Stored
procedure. Opens in under 2 seconds but still takes forever to move to the
last page.

Given I need to move very quickly from page 1 to page 500 would it be better
to create an populate a local table with the date and take the hit before
the form loads??



Comments??


Martin