Recent content by Murli

Use the Group By in your query and max on the date field.

Try this: =IF(AND(A2=A1,(B2-B1)>90),"OVER 90 DAYS","")

This can be done using a macro. Type the below code and run the macro : Sub mymacro() For i = 3 To Sheet1.Range("A65536").End(xlUp).Row x = Sheet1.Cells(i, 6).Value Sheet1.Select Rows(i).Select Selection.Copy Sheets(x).Select rown = Sheets(x).Range("A65536").End(xlUp).Row Sheets(x).Range("A" &...

I was able to get that using two queries. Query1 : calculate the max of effective. Query 2: use the base table and query 1 - use innerjoin to get all the fields for that max(effective). Let me know if that works.

You have to query on the original query and the order detail table to get the results. Including the sql in the original query wont work.

You have to write another query on the current one to get the unit price, quantity and other details.

Remove Field 7 - Shipping method and Field 8 - Salesman name from your query and you would have the results.

What do you mean by Across the tables? Please explain...

Instead of average use expression to get the average of the sum of two columns. SELECT Sum([tele].[calls handled]) AS [SumOfcalls handled], Sum([tele].[total speed answer]) AS [SumOfanswers speed], [SumOfanswers speed]/[SumOfcalls handled] AS Expr1 FROM tele; Let me know if that works.

By checking the checkbox the system auto changes the queryname if changed by the user.

Go to Tools->Options -> General -> Check the Track name AutoCorrect info checkbox.

Heres a sample: I could do it using three queries. May be theres a simpler way that i am not aware of. Just go the the form1 in the attached DB and enter the date and click the command button. Let me know if that helps.

Not In or In is used instead of <> or = with SQL statements. You could use them anywhere in your sql statements.

Use this in your criteria section: Not In (select UserId from tblUserData) Murli

Very much possible Hi, For your given output you need to group by the Business name, consultancy type and sum the hours spent with a condition on the dates. Sum for each business name may be generated directly at the report level using a sum operation at the businessname footer level. (see...