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

create a field based on another field

P: n/a
I have a field called AMOUNT in MS Access with values of 10, 20, 30, 40, and
I want to create another field called TOTAL like this: if the value in field
AMOUNT=20, then TOTAL=AMOUNT*3, else TOTAL=AMOUNT*5. Could someone point me
how to do this.

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
use an IIF statement inside your query, don't put it in your table.
Just calculate the thing on the fly. Well, at least if it ALWAYS obeys
the same rule.

MyTotal:IIF(Amount=20, 60,Amount*5)

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.