Summary Report

#1 (**permalink**) 28-Jul-2006, 08:36 AM

Is it possible to have a report that draws from multiple queries or tables?
For example, I have one query which counts shipments, one query which counts
units returned, and one query which counts damaged goods. I'd like a report
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13402-summary-report.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13402
which shows the results of all three queries which are totally unrelated.

Thanks,

*

#2 (**permalink**) 28-Jul-2006, 08:36 AM

You will ned to use subreports and not define any parent child relationships
to be able to have all of these on one report if there is no relationship.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13402

"Francophone" wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13402
> Is it possible to have a report that draws from multiple queries or tables?
> For example, I have one query which counts shipments, one query which counts
> units returned, and one query which counts damaged goods. I'd like a report
> which shows the results of all three queries which are totally unrelated.
>
> Thanks,

#3 (**permalink**) 28-Jul-2006, 08:36 AM

SELECT 'Shipment' AS Code, Count(*) AS CNT FROM SHIPMENTS
UNION ALL
SELECT 'Returned' ,COUNT(*) FROM UnitsReturned
UNION ALL
SELECT 'Damaged', Count(*) FROM DAMAGED

Would do it

Pieter

"schasteen" wrote in message
news:E23B15A1-5B83-4A67-93DA-E324BB88792F@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13402
> You will ned to use subreports and not define any parent child
> relationships
> to be able to have all of these on one report if there is no relationship.
>
> "Francophone" wrote:
>
>> Is it possible to have a report that draws from multiple queries or
>> tables?
>> For example, I have one query which counts shipments, one query which
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13402
>> counts
>> units returned, and one query which counts damaged goods. I'd like a
>> report
>> which shows the results of all three queries which are totally unrelated.
>>
>> Thanks,

#4 (**permalink**) 28-Jul-2006, 08:36 AM

SELECT 'Shipment' AS Code, Count(*) AS CNT FROM SHIPMENTS
UNION ALL
SELECT 'Returned' ,COUNT(*) FROM UnitsReturned
UNION ALL
SELECT 'Damaged', Count(*) FROM DAMAGED

Would do it

Pieter

"schasteen" wrote in message
news:E23B15A1-5B83-4A67-93DA-E324BB88792F@microsoft.com...
> You will ned to use subreports and not define any parent child
> relationships
> to be able to have all of these on one report if there is no relationship.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13402
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13402
>
> "Francophone" wrote:
>
>> Is it possible to have a report that draws from multiple queries or
>> tables?
>> For example, I have one query which counts shipments, one query which
>> counts
>> units returned, and one query which counts damaged goods. I'd like a
>> report
>> which shows the results of all three queries which are totally unrelated.
>>
>> Thanks,

--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4231 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len