report freezes DB

[JCross]

It's very big, and complex and runs on dozens of queries and eight subforms. Each individual component runs fine on its own, but when run together they freeze. I've done everything I can think of in the way of simplifying the queries.......any ideas?

Thank you!

Jennifer

 

[yellow]

Stupid Question: Are you sure it's freezing and not just taking a very long time to run?

 

[JCross]

After I posted I thought of that too! And sure enough....it's a report that takes around 15 minutes to run. Thanks for thinking of it.

Jennifer