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

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

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

Hello, Recently we got a new version of our Finance application ( Navision Software ). Consequence is that many of my Crystal Reports made with the former version, are worthless. Problems are: (1) When I try to refresh the reports I got the following statement: ODBC error: "[Navision...

I have just heard from your site, and this is exactly what I'm looking for because CR isnot the most easiest application. I've the following issue which I want to put in a crosstab ( if possible ): Each month we report our projectresults/ -turnover to our parentcompany. Our ( monthly )...