Recent content by sundaram

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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