Search results

Thank you very much to Rabby and Dennisk for helping me My problem is solved last formula is exactly working for me Thanks again Bye Take Care Ashish

When this is my formula then where i have to put that round(realvalue+0.5,0) Commission: Round(IIf([Amt]<=10000,30,IIf([Amt] Between 9999 And 15000,50,IIf([Amt]>15000,[Amt]/1000*3.5)))) please reply me for this Urgently Ashish

I can't get that point how its work Thanks Ashish

problem but sir it must be create a problem when value is 144.59 or something like that becaue i required that when value is 144.59 then also it will be show 145 so there is any solution for this or not Please tell me and thanks for your reply Ashish

Simple Problem I think I got that formula Commission: Round(IIf([Amt]<=10000,30,IIf([Amt] Between 9999 And 15000,50,IIf([Amt]>15000,[Amt]/1000*3.5)))) and then after I create a coloumn Salewithcoloumn : Sale + Commission I think I choose right manner to do this But I have one problem is...

Hi Sir Firstly I want to thanks access forums member who always help me and give me a appropriate reply. Today my problem is that I have many coloumns in my table But I want to put a formula in the single coloumn Sales 10000 5000 65000 35000 15000 14400 100000 52330 Out of this sale we have...

Thank you sir for your reply Thanks Ashish

Thanks for reply sir I have a lot of columns in my table but I want to put a formula in single row I just try and reply you about this formula it is working for me or not Thanks again for your reply Ashish

I have 2 coloumns Size------------Sale (in bottles) 750------------900 1000-----------450 750------------30 90-------------80 1000----------60 90-----------57 Now I want to create a query containing one more coloumn which is Sale (in cases). If size =750 it divided by 12, If size =1000 it...

How can we calculate a difference of column Example when I have a table containing a single row i.e. Numbers 66 45 23 52 523 563 452 133 Now I required a query that must show a difference like this Numbers ------------------ Difference 66 ------------------------ 0 45...

Thanks Thanks Bob Larsen I got that thing I don't have a knowledge for this Thank you again Ashish

Hi its may be a very stupid question But I don't know about that can you please tell me how we able to enter a Header and Footer in the report By default there is Report Header, Report Footer and Page Header and Page Footer and Detail But when we want to insert any other header and footer...

I have two coloums Months----------Sale April--------------45 April--------------56 April--------------35 April--------------52 April--------------45 May--------------75 May--------------100 May--------------62 May--------------85 June--------------23 June--------------42 June--------------52...

I have two coloums Months----------Sale April--------------45 April--------------56 April--------------35 April--------------52 April--------------45 May--------------75 May--------------100 May--------------62 May--------------85 June--------------23 June--------------42 June--------------52...

Months Sale April 45 April 56 April 35 April 52 April 45 May 75 May 100 May 62 May 85 June 23 June 42 June 52 June 45...

Hi sir I have Two colums Name Date Ashish 06/05/2007 Ashish 05/03/2007 Ashish 10/07/2007 Sachin 30/05/2007 Sachin 10/08/2007 Sachin 09/07/2007 Ajay 25/06/2007 Ajay 30/05/2007 Ajay...

Thanks Thankyou for your reply

Commission: IIf([Amt]<=10000,30), IIf(Int([Amt]/1000 Between 10000 And 50001)*3.5+3.75) What I required to do is that when amount is greater than or equal to 10000 than Amt multiply by 30 simply. and when amount is between 10000to 50001 than Amt/1000 multiply by 3.5+3.75 means that when amount...

Commission: IIf([Amt]<=10000,30), IIf(Int([Amt]/1000 Between 10000 And 50001)*3.5+3.75) What I required to do is that when amount is greater than or equal to 10000 than Amt multiply by 30 simply. and when amount is between 10000to 50001 than Amt/1000 multiply by 3.5+3.75 means that when amount...