Search results

  1. A

    Creating Formula

    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...
  2. A

    creating query

    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...
  3. A

    Difference in Numbers

    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...
  4. A

    Header footer

    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...
  5. A

    problem in report

    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...
  6. A

    Problem in creating report

    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...
  7. A

    Problem in report

    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...
  8. A

    Creating Report

    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...
  9. A

    Help Required

    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...
  10. A

    Help Required Urgently

    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...
Back
Top Bottom