IF THEN Statements

[Ashkan]

Hello,

I am making a small DB in Access to track my Ebay sales. I have a table with a SoldItems field. I want to make a report that will calculate the Final Value Fees so I don't have to enter it my self.

If the Final Sale price of an item is between $0 and $75 then I will be charged 5.25%. $75 to $1000 I will be charged 5.25% up to $75 and 2.25% for the rest.

I can't get it to work. This is all I have done so far:

If [SoldPrice] < 75 Then [FinalValue] = [SoldPrice]*1.052

Thanks

 

[KenHigg]

I would do this in a function as you may need it it several places.

 

[Ashkan]

how would i do a function

i am new to access

 

[KenHigg]

Never mind. Where are you trying to put your code that calculates the charges?

 

[Ashkan]

in a report, i am trying to do it in the control source

 

[Brianwarnock]

I must have missed something here 5.25% of 1000 is 52.5 so when does the rate change? ie when does the fee become greater than $75

Brian

 

[KenHigg]

In the control source for the text box on the report, you can do something like:

= iif([SoldPrice]<=75, [SoldPrice] *1.0525, iif(([SoldPrice] > 75) and ([SoldPrice] < 1000 , [SoldPrice] *1.0325, [SoldPrice] *1.0225

I have not tested it but it should work. Basically, you just embed iif statements...

Here is a mdb with a simple fuction where the function is used in a query and in a form. Poke around with it and see if you can figure out how it's working...

 

[Ashkan]

if the final price of the item is less than $75, then there is a 5.25% fee. if the item sells for more than $75 then the fee is calcauted by charging 5.25% for the first $75 and 2.25% for the reminder

could you please give me the code required to calculate this?

 

[KenHigg]

= iif([SoldPrice]<=75, [SoldPrice] *1.0525, (([SoldPrice]-75) * 1.0225) + 3.94))

???

 

[Brianwarnock]

I'm having terrible performance problems communicating with this site I'm giving up

Brian

 

[Brianwarnock]

I would do it in the query but wherever you do it

finalcost: IIf([soldprice]>75,(soldprice+([soldprice]*0.0525)+(([soldprice]-75)*0.0255)),[soldprice]*1.0525)

Brian

 

[Ashkan]

thanks