Search results

  1. sundaram

    I have the following data table. Please help me out with suitable countif formula. Ref: No...

    I have the following data table. Please help me out with suitable countif formula. Ref: No Revision Item Grade D001 0 Civil D D001 1 Civil C D001 2 Civil B D001 3 Civil A D002 0 MEP-VE C D003 0 STR B D004 0 MEP-PL A D005 0 MEP-EL D D005 1 MEP-EL C D005 2 MEP-EL C D005 3 MEP-EL C...
  2. sundaram

    Not working in window 7

    Dear Friends, Revious I was using windows XP, and now i am using windows 7, Since then my data base is not working, even query, form are not working. Only table is opening. Can any one help me how to operate in windows 7. Regards, RAJAMALL
  3. sundaram

    I have data base in xp version Now i am using windows 7 and now it not opening in windows 7

    I have data base in xp version Now i am using windows 7 and now it not opening in windows 7
  4. sundaram

    Query - TotalSalesAmt - TotalPurchaseAmt = Profit/Loss

    Dear Sirs, SELECT TblTran.ItCode, TblTran.Item, TblTran.TUnit, Sum(TblTran.TQty) AS SumOfTQty, Avg(TblTran.TRate) AS AvgOfTRate, [sumofTqty]*[AvgofTrate] AS TotalAmt, TblTran.TTranscatType FROM TblTran GROUP BY TblTran.ItCode, TblTran.Item, TblTran.TUnit, TblTran.TTranscatType; I have the...
  5. sundaram

    Report - Profit / Loss

    SELECT TblTran.ItCode, TblTran.Item, TblTran.TUnit, Sum(TblTran.TQty) AS SumOfTQty, Avg(TblTran.TRate) AS AvgOfTRate, [SumofTQty]*[AvgofTrate] AS SalesTAmt, [SumofTQty]*[AvgTRate] AS PurchaseTAmt, TblTran.TTranscatType FROM TblTran GROUP BY TblTran.ItCode, TblTran.Item, TblTran.TUnit...
  6. sundaram

    Report - Profit / Loss

    Dear, I have done as per the blow code, But the out put is not correct. SELECT TblTran.ItCode, TblTran.Item, TblTran.TUnit, Sum(TblTran.TQty) AS SumOfTQty, Avg(TblTran.TRate) AS AvgOfTRate, [SumofTQty]*[AvgofTrate] AS SalesTAmt, [SumofTQty]*[AvgTRate] AS PurchaseTAmt FROM TblTran GROUP BY...
  7. sundaram

    Report - Profit / Loss

    SELECT TblTran.ItCode, TblTran.Item, TblTran.TUnit, Sum(TblTran.TQty) AS SumOfTQty, Avg(TblTran.TRate) AS AvgOfTRate, [sumofTqty]*[AvgofTrate] AS TotalAmt, TblTran.TTranscatType FROM TblTran GROUP BY TblTran.ItCode, TblTran.Item, TblTran.TUnit, TblTran.TTranscatType; Sir, I have done as per...
  8. sundaram

    Report - Profit / Loss

    1. ProfitLoss: IIF(IsNull([Sales Total Amt] - [Purchase Total Amt]), Null, IIF(([Sales Total Amt] - [Purchase Total Amt]) = 0, 0, IIF(([Sales Total Amt] - [Purchase Total Amt]) < 0,"-","+"))) I have tried to run the query it is asking me SalesTotalAmt, PurchseTotalAmt 2. ProfitLoss...
  9. sundaram

    Report - Profit / Loss

    My question here is that, you see the report which is created with the help of wizard. Is it possible to edit it to get a report of Total (Sales) - Total (Purchase) to get profit or loss (amount). In the mean time I have created one query, trying get the above result in the query. But i...
  10. sundaram

    Report - Profit / Loss

    Thanks for your kind response. I have copied your code and tried but I am not getting the result. In query. Please help me. Also i have tried to make a form. trying to open it. It is showing error. I am attaching the database file. Thanks&Regards, RAJAMALLU
  11. sundaram

    Report - Profit / Loss

    I mean to ask you that is there any syntex that it should show Sales Total amt - Purchase Total Amt = xym amt (Number) in the reprot. Or Is it possible to get the above answer in query. If yes then can you please guide me. I appreciate in Advance. RAJAMALLU
  12. sundaram

    Report - Profit / Loss

    As per your advise I have added additional column and named it as TTranscatType. I have merged all the transcations in one table as TblTran Date,ItCode,Item,TUnit,TQty,TRate,TTtlAmt,TTranscatType I have created a report with the helpe of report wizard. I got the sum of Total of TQty and...
  13. sundaram

    Help the needy If you can't help, try to show them who can help them.

    Help the needy If you can't help, try to show them who can help them.
  14. sundaram

    Report - Profit / Loss

    Thanks for your kind response. 1. Table - TblMasterInv 1.ItCode and 2.Item (ItCode is the primary key) 2.TblPurTrn DateItCodeItemPUnitPQtyPRatePTtlAmtPAvgRate 3.TblSalTrn DateItCodeItemSUnitSQtySRateSTtlAmtSAvgRate From the above table no. 1 and table no. 2. I need report showing : Itcode...
  15. sundaram

    Report - Profit / Loss

    I have two tables 1. Purchase - a. Date, Code, Item, Qty, Unit, Rate, Total Amt 2. Sales - a. Date, Code, Item, Qty, Unit, Rate, Total Amt I need a report comprehsive, showing the updated qty and sales - Purcase. Thanks in advance. Regards, RAJAMALLU R
  16. sundaram

    Primary key

    Dear Mr. gemma-the-husky Thanks for your reply I am have set the empdte as primary key in the table tbltime. General setting tab from drop down(No, Yes Duplicates OK & Yes (Duplicates OK). I am setting to Yes Duplicates OK. Then it is showing error "It is showing that Removing or changing...
  17. sundaram

    Form - Count Number of days

    Dear Friends, I have table which has: TblResult fields are Fields Date Type Docmentdt as date Description as Text Submitteddt as date Replydt as date NoofDays as Number Now, I want see in Noofdays column that total days if the submitted date...
  18. sundaram

    Query in a Form

    Thanks very much your coding example helped me a lot. You are excellent.
  19. sundaram

    Primary key

    Still it is giving trouble please help me out.
  20. sundaram

    Primary key

    Dear gemma-the-husky, As per your adivse I have made empid as primary key in table tblEmp AND the empdate in table tblTime. empdate as primary key (with allow duplicates false) which is not accepting in table design. "It is showing that Removing or changing the index for this filed would...
Top Bottom