Database Structure

  • Thread starter Thread starter LilP
  • Start date Start date
L

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?
 
Hello LilP.

LilP said:
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?
Click to expand...

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.
 
LilP said:
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?
Click to expand...

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