Database Structure

[LilP]

I have a database that I created for use in our department to track
employees. Can I have 2 seperate databases and have data from each show in a
report?

Also - Can functions on an excel sheet be imported into Access?

 

[Wolfgang Kais]

Hello LilP.

I have a database that I created for use in our department to
track employees. Can I have 2 seperate databases and have data
from each show in a report?

Also - Can functions on an excel sheet be imported into Access?

You can link tables from other databases to your database and use
them as if they were tables stored in your database, for example for
a report.
Functions from an excel sheet can't be imported to Access, but I
think that Access also must of the functions that you can use in a
worksheet.

 

[Tony Toews [MVP]]

I have a database that I created for use in our department to track
employees. Can I have 2 seperate databases and have data from each show in a
report?

Why would you have two separate databases?

You can also use the IN clause in a Union query.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/