Help...create a report that pulls from multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a VERY new Access user...

I have 15+ tables, each with identical field names (linked sprdshts from
Excel), and each containing schedule information for a specific project.

I am trying to create an interface that would allow each project manager to
update their spreadsheet...and utilizing access to create different reports.
However...I can't seem to figure out how to do that...

I have Office 2003 - but the database I have open says it is in 2000 format.

Can the program even do what I need?
 
What exactly do you want to do in Access. You won't be able to update the
Excel data if you have the latest service packs applied. If you want to
create a report of multiple linked worksheets, you might be able to create a
union query and use that as the basis for your reports.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't create a report from my query in Access 1
Multiple tables - need 1 report 1
Creating a Report from Multiple Tables 1
Access Sorting and grouping using multiple tables 0
very new to access and need major help 10
Reports 1
vba code help for multiple string searching 0
Counting multiple memberships 1

Back
Top