linking databases

B

bobc721

I have 15 timesheets that have the same fields that I need to combine into
one and do reports. Is there an example or template to do this?

I am thinking of linking the databases but not clear on how to build the
queries or reports if I do it this way. My other option is to query the
linked and make a new database.

Appending the files would entail capturing almost 5 years worth of
information in some files creating a huge database. I am only wanting to get
monthly summaries and then at the end of the year combine the monthly
summaries into a annual summary.... any ideas on the best way to grab parts
out of many?
 
Top