Comparing reports between 2 differ DBs

  • Thread starter Thread starter Jeannette
  • Start date Start date
J

Jeannette

Hi!,

I am currently developing an Access application (Access
97) to compare the value of certain fields in reports
within an Access database and between two different Access
databases. My questions is that how can I compare the
value of the fields in reports between two different
databases? Please advise.

Any help would be greatly appreciated! Thanks in advance.

Jeannette
 
Jeannette said:
I am currently developing an Access application (Access
97) to compare the value of certain fields in reports
within an Access database and between two different Access
databases. My questions is that how can I compare the
value of the fields in reports between two different
databases?
Click to expand...


The secret to getting started on any report is to design a
query that retrieves the needed data in an appropriate
arrangement.

In your case, it sounds like you only need to Join the data
in one table to the data in the other table. So your first
task is to determine how you're going to connect the data
that you want to compare.

In a simple situation the records in the two tables would
have the same primary key values and you would only need to
Join on the key fields. A simple example could be something
like:

SELECT T1.F1, T1.F2, T2.F1 As G1, T2.F1 As G2
FROM T1 LEFT JOIN T2 IN "pathtoseconddb"
ON T1.K = T2.K
 
Back
Top