Search results for query: *

A short one; If I have date value 17/08/2005. With which formula do I get the date notation: (1) 08-2005 ( month-year ) (2) 03-2005 ( quarter-year ) Regards, GEO40

To all, Thanks for the support; Now what if I add two more conditions/ dimensions to the formula: -Department; -Own employee or hired personnel; I want to count if the employment date of a employee is within the given date range, and when the employee is working on a specific department...

COUNT-IF function. I want to count if the employment date of a employee is within the date range. So if I want to see how many persons start working at our company in August, I have to insert a between construction in the count-if formula: between 01/08/2005 and 31/08/2005. But the question is...

Dear all, I'm not a frequent user of MS Access. Perhaps a simple question, perhaps not. In a MS ACCESS-report I want just a few rows bold: 1000 NETHERLANDS ( this row bold coloured ) 1100 Amsterdam 1200 Rotterdam 1300 The Hague 2000 BELGIUM ( this row bold...

Hello, I've to sum up our turnover for July 2003 for our Agriculture customers. So only the turnover for period 7 ( july ) from our agriculture customers will be in my report. DATABASE Period Customer Invoice(EUR) Area 5 A 1500 Agriculture 6 AA 1500...

Dear all, In a drill-down report, I put three customers with their total outstanding invoice-amount. On the report I want the total outstanding amount of each customer. So I summ up the individual amounts. However one of the customers do not have an outstanding saldo ( All invoices have been...

Dear Sirs, I managed a database for invoicing. The database contains a lot of self-made columns, and data-input by self-generated MS Access forms. So a lot of valuable information has been generated. These database is used by several persons. My problem is that after I print my invoice, I or a...

I'll make a TOP 10 report in the CrossTab. I know that I can put the following formula in my report : WhileReadingRecords; NumberVar TEST =: TEST + 1; Issue: I have 40 records from a specific field with a amount. Now I want the TOP 10 amounts. After I put mentioned formula in my report I...

Hello Ken, The formula you suggest works. Thank you for that. The remark you added in your last mail is right. So when I go back to my example I have to take the difference between the maximum and minimum total driven miles in the period. This calculation I've to divide by the total quantity...

Thanks for responding so quickly Ken. (4) What I want to do is to subtract the maximum of the miles in the period from the minimum of the miles in the period so I will get the driven miles in the period. With which formula can I do this ? (5) Then I want to divide the driven miles by the sum...

Hello, In a table for a certain car I've got following fields: Date Qty. petrol(ltr) Amount (H)Odomtr 2002/04/01 52,2 53,24 15500 2002/04/11 47,4 46,45 16069 2002/04/15 53,4 54,20 16843 2002/04/23 29,3...

EXCEL Question: Each day I run a report at the same time ( 10h00 ) of the amount of our outstanding invoices. This changes every day. The question is whether it is possible that I can save this data in another sheet in the same file ? Sheet1 gives following data, and will be refreshed every...

Question: In EXCEL I want a average of the costprice of the employees ( who still work at our company )per business unit. I've got the following fields: Costplace Person Date of discharge Costprice 101 A 40 101 B...

Can anyone help me with following issue : On one sheet I've got several costplaces with its projectnumbers. Next to it on the same sheet I've got a table with the percentage of the project what's completed till so far. Costplace Projectnumber %-completed of work in progress 101...

I think this one is not so difficult, but anyway I cannot manage this issue. I've two columns Costplace Pieces 101 12 101 18 201 30 201 25 301 50 301 35 301 26 Now I need a formula which gives me for each costplace the maxima...

Dear Mymou or others, I tried following formula: {=sum(if((Sheet1!$A$2:$A$7=A2)*(AND(Sheet1!$C$2:$C$7>=31,Sheet1!$C$2:$C$7<=45));1;0))} I should get &quot;2&quot; as answer, but I get &quot;0&quot;. What is it that I do wrong ? By the way: could you describe the &quot;Countif&quot...

To everyone who helped me I can say: Thank you very much. In the formula I've replaced the &quot;,&quot; for a &quot;;&quot; and this works. Indeed Mymou you were right because the totals aren't right. In one formula I need a criterium that says: >= 31 days and <= 45 days outstanding. Any...

Please can you be more specific ? When I entered your formula I got an error-message. I think this has to do with the &quot;1&quot; and &quot;0&quot; in your formula. I also don't understand what you mean by &quot;enter as an array formula&quot;. Thanks in advance.

Hello, I hope someone can help me with following issue in MS Excel. I've following columns in our OFFER-database: Cost-place Project Days outstanding 101 A 22 101 B 45 201 C 95...

When I want to create a new report, the problems are the same. So indeed I'll have a few words with folks of Navision. Thanks anyway.