Dear all
I have a table name detail with two fields type and amt. typer is a
character field and the amt is numeric field. The type field contains
the type of transactions like RT OR PT and the amt field contains the
value for each transaction. I am trying for a query with result to
obtain total of PT minus total of RT. I have tried to use following
statements in the query:-
SELECT a.totrep , b.totpay, (b.totpay-a.totrep) AS Expr1
FROM [select sum(amt), totrep from detail where type='RT']. AS a,
[select sum(amt), totpay from detail where type='PT']. AS b;
The above query when considers totrep and totpay as a variable. Is
there a way out for the above problem?
Thanks in advance.
Krishnadas
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
