Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Tupence
  • Content: Threads
  • Order by date
  1. Tupence

    Average of quickest 80% of cycle times

    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?
  2. Tupence

    grouped IIF statement to search for specific words in a field

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

    Please help me with my string formula

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

    Removing 0 from a distinct count of an if statement

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

    Formula for field containing a word

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

    "Database table not being found" error message

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

    Date Field- group into quarter

    Hiya All, I've got data with a date field in it. I have been able to sort this by week and month, but am struggling to group data into quarter. Any ideas? Thanks Tups

Part and Inventory Search

Back
Top