We've recently upgraded some of our workstations to Windows XP (We're using Access 2000 not Access XP)and are now finding that some of the reports in our job order system are taking an exceptionally long time to display.
The queries behind these reports are pretty complicated with a lot of criteria (some of which is pulled from fields on a form) and a few iif() functions.
Not all the reports are slow, and the reports in question continue to work fine on Win 98 workstations. The reports do eventually display, it just takes a while.
Any thoughts?
The queries behind these reports are pretty complicated with a lot of criteria (some of which is pulled from fields on a form) and a few iif() functions.
Not all the reports are slow, and the reports in question continue to work fine on Win 98 workstations. The reports do eventually display, it just takes a while.
Any thoughts?
