1 query or many?

  • Thread starter Thread starter Maracay
  • Start date Start date
M

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
 
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
 
Back
Top