Recent content by Tupence

the cycle formula is purely closed date - placed date to give number of days. I don't realy understand how a running total will help me calculate the average top 80% though?

thanks but i need to 1 sort the number of days formula ascending 2 count number of records 3 work out 80% of them 4 then average the 80% TopN doesn't work for this. I have tried using a formula in section expert to suppress records after 80% of the total number recordnumber > count ({@cycle...

I have a formula cycle time which calculates the number of days between order placement and order closing. I am now trying to calculate of the quickest 80% what is the average number of days. Can you help?

Sorry, novice mistake! ha ha

i have checked the MS access functions and this one doesn't appear. Any other suggestions? thanks.

I have a list of company names that i want to write a grouped IIF statement to bring back results of only those with Limited, LTD or plc. in the field, these are always at the end of the string, I have thought about using RIGHT function but I have also found the Instr function but don't know how...

Thanks Kid, really helped me out.

Hi, I'm trying to find a way of counting how many payments count{charges.ncharge} and how much sum{charges.ncharge}have been made "by us" and "by client", the only place in my database where this info is found is in an automatically generated comment string field {comment_.ccomment}. I am not...

Thanks for the suggestion but when the two tables are linked the date appears multiple times as there are numerous daily requests. the sum just brings back a really high figure.

I have a created a report with a table with unique identifier, contact info and daily requests on it for 2006 and on another table the premium service start date which are linked via the unique identifier. I am trying to do a distinct count of premium users in 2006, i have written an if...

Thanks, that worked a treat!

Hi All, I am trying to find a formula for finding a six letter string within a field, in order to create a group unfortunately the way the data is entered the six letter word could be anywhere in the field. is there a formula function that could be used to do this? thanks

I have just had an upgrade cr 11 licence installed on my pc, the odbc link is working fine, but when i refresh reports which were created using cr 8.5 an error message appears stating that the tables are not found and asks if i want to remove these from the report. If i press no the data comes...

the group total would give me the entire year, i want four totals one for each quarter. Sorry i'm not explaining this too well...........

Thanks anyway, but I want to create a formula that will combine results from individual months to give a value for the relevant quarter.