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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kozamel@hotmail.com - 26 Apr 2006 19:28 GMT

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?

Reply to this Message

Duane Hookom - 26 Apr 2006 22:22 GMT

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.

Signature

Duane Hookom
MS Access MVP

>I am a VERY new Access user...
>
[quoted text clipped - 11 lines]
>
> Can the program even do what I need?

Reply to this Message