1 query or many?

[Maracay]

Hi guys,

I am developing around 15 reports, all of then have a common query, very
detail query, and from this query I generate the reports or generate another
queries that generate the reports, I am going to Splitting the data base to
make it multi-user in this scenario and thinking about performance, what
should I do, keep working with 1 query as the base of all my reports to keep
the number of queries low or to create a base query for every report.


Any help will be appreciated

Thanks

 

[Ron2006]

With only a few exceptions, a split application (tables in one MDB and
forms etc in another) is coded no differently than if everything was
in a single MDB.

No other changes are usually necessary for existing queries, etc. and
the creation of queries is the same as if the table was internal.

Ron