467,917 Members | 1,302 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

Subtract values in a field from a number?

I wanna take 300 and subtract it by a value inside a field and i want the results to display in a new field called "Oustanding Fees."


The field is called "FeesPaid" and the field contains the amount the person has paid. Anyone who hasn't paid 300$ still owes money. For example there is a value inside the field 125.... how would i subtract that and all the other values in the field from 300?
Nov 28 '08 #1
  • viewed: 3462
Share:
1 Reply
SELECT 300-FeesPaid AS OutstandingFees
FROM Fees
Dec 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by abs | last post: by
19 posts views Thread by cover | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.