calculate in a view?

[jazminecat]

Hi, I have the following in a view, which produces correct results thus far:

SELECT AGAN8, AGALPH, AGBHBB AS BegBal, AG#XC1 AS Taken,
AGPDBA
FROM Finance_Admin.JailSummary
WHERE (AGPDBA BETWEEN N'8200' AND N'8299')

Now I want another column that takes the number in BegBal, Subtracts Taken, and returns a new number.

I am unfamiliar with ADP, work mostly with access and vba, so any help you can provide would be greatly appreciated.
Thanks!

 

[jazminecat]

I figured it out. Here's what i got, in case anyone else needs the syntax:

SELECT AGAN8, AGALPH, AGPDBA AS Type, AGBHBB AS BegBal, 
    AG#XC1 AS Taken, AGBHBB - AG#XC1 AS EndingBalance
    
FROM Finance_Admin.JailSummary
WHERE (AGPDBA BETWEEN N'8200' AND N'8299')

easy peasy!