Combine query

[sanket044]

SELECT sum(GoodsRcpt.PurchQty) FROM GoodsRcpt where GoodsRcpt.GlsClr=" WHITE";

SELECT count(Prescriptions.SrNo)/2 FROM Prescriptions where
Prescriptions.GlsClr=" WHITE";

SELECT sum(GlassDamage.DamageQty) FROM GlassDamage where
GlassDamage.GlsClr=" WHITE";

Combine above three query and the equetion should be like, (result of
query1) - ( result of query 2 + result of query 3)

its urgent...
Thank you....

[wen_cai]

Try the sql below:

select (SELECT sum(GoodsRcpt.PurchQty) FROM GoodsRcpt where GoodsRcpt.GlsClr=" WHITE") - ((SELECT count(Prescriptions.SrNo)/2 FROM Prescriptions where Prescriptions.GlsClr=" WHITE") + (SELECT sum(GlassDamage.DamageQty) FROM GlassDamage where GlassDamage.GlsClr=" WHITE")) AS result;

[sanket044]

ACTULY I AM TRYING A QUERY IN MS ACCESS..
IT GIVES ERROR AT " AS RESULT"

[wen_cai]

I see. Because I normally do that with SQL Server. It has been sometime since I last use MS ACCESS. Give me some time to figure it out.

[vjcagay]

Some databases don't support multiple queries combined into one.. so you can do nothing with it but execute them separately..

[sanket044]

okay thank you all...