469,331 Members | 1,912 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Formula's results in a form update the table?

1
Hi

I have a database that I use for tracking ebay sales and profits.

My sales table has a form that contains the ebay fees calculation but it won't update the sales table with the results from the formula (formula listed below)

=IIf([Sale Price]>1000,(29.375+(([Sale Price]-1000)*0.015)),IIf([Sale Price]>75,(3.9375+(([Sale Price]-75)*0.0275)),[Sale Price]*0.0525))

This formula is working in the form
Jul 4 '07 #1
1 1015
pbmods
5,821 Expert 4TB
Heya, mkheys. Welcome to TSDN!

What language are you using to program your application?
Jul 4 '07 #2

Post your reply

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

Similar topics

reply views Thread by Phil Powell | last post: by
1 post views Thread by James M via SQLMonster.com | last post: by
1 post views Thread by Roy | last post: by
3 posts views Thread by Mike | last post: by
1 post views Thread by Neo Geshel | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Purva khokhar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.