By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,948 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

Subtract values in a field from a number?

P: 4
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
Share this Question
Share on Google+
1 Reply

P: 6
SELECT 300-FeesPaid AS OutstandingFees
Dec 5 '08 #2

Post your reply

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