Re: Report from multiple databases
- From: "Bill Edwards" <billedwards@xxxxxxx>
- Date: Wed, 28 Jun 2006 13:07:23 -0500
Option 1:
Link the tables from the different databases to your access mdb. Access the
data in the tables as you would any other linked table.
Option 2:
Create a view or stored procedure in one of the databases that uses fully
qualified table names to summarize/gather/whatever information from the
tables in the other three databases. e.g. SELECT blah, blah, blah FROM
MyServer.Northwind.dbo.Customers as NWCust INNER JOIN
MyServer.Pubs.dbo.Client as PC on NwCust.CustomerKey = PC.CustomerKey
INNER JOIN MyServer.Library.dbo.Patrons AS P ON NwCust.CustomerKey =
P.CustomerKey
"Deki" <Deki@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3857FF4C-1DF0-49A3-B981-47EC1F4318B8@xxxxxxxxxxxxxxxx
Hello,
I'm trying to create 2 reports. I have SQL Server 2000 and Access 2003.
Report should be done in Access. There are 4 different databases on same
SQL
Server.
I need report showing:
CustomerID
AgencyName
State
TotalDVI
TotalDRI
TotalVI
......
Totals are counts of all files in corresponding tables for all 4
databases.
To add to this problem, one database has different names of tables and
fields in them then other 3 databases.
Databases are definitely a mess and I can't do anything about it at this
time.
Is there a way to accomplish this?
Deki
.
- Prev by Date: Re: Lost Fonts
- Next by Date: Re: Macro to email PDF file
- Previous by thread: Re: Time Format in a Query
- Next by thread: Convert Minutes to Hours:Minutes
- Index(es):
Relevant Pages
|
