Report From 2 Tables

[zyus]

Is it possible to produce report that based on 2 different tables and there's
no link between those tables.

For ex.

Tbl-A
acno
amount

Tbl-B
idno
netbal

Can i do count([acno]) and count([idno]) in a report based on the two table.

Thanks

 

[Tom Wickerath]

Hi Zyus,

I suppose you could base your report on a Union Query. Something like this:

SELECT acno, amount, Null As Indo, Null As NetBal
FROM [Tbl-A]
UNION
SELECT Null As Acno, Null As Amount, indo, netbal
FROM [Tbl-B]


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Ray]

I suspect Tom is on the right track, with a minor change. This is something
I've done in the past:

SELECT 'Tbl-A', Sum(amount) FROM [Tbl-A]
UNION
SELECT 'Tbl-B', Sum(netbal) FROM [Tbl-B]

 

[Tom Wickerath]

Hi Ray,

That depends....if Zyus does not care about any of the detail records, but
only sums of the amounts, then your method is fine. On the other hand, one
can always do summing in a report.

Zyus: I thought of an alternate method that might be more appealing to you,
versus using a Union query. Create separate reports based on each table.
Then, insert these two reports as subreports into a third (parent) report.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

:

I suspect Tom is on the right track, with a minor change. This is something
I've done in the past:

SELECT 'Tbl-A', Sum(amount) FROM [Tbl-A]
UNION
SELECT 'Tbl-B', Sum(netbal) FROM [Tbl-B]

__________________________________________

:

Is it possible to produce report that based on 2 different tables and there's
no link between those tables.

For ex.

Tbl-A
acno
amount

Tbl-B
idno
netbal

Can i do count([acno]) and count([idno]) in a report based on the two table.

Thanks