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!

  • Congratulations TouchToneTommy 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: Kelser
  • Content: Threads
  • Order by date
  1. Kelser

    Advanced Filter Excel 2007

    What I want to do: IF the row in Column AG and AH are both blank then don’t show that row, but if only one of the columns contain a blank or both contain data then show that row. I tried this with an advanced Filter, doing an AND but it doesn't work. If I filter using <> under 1 column...
  2. Kelser

    How do I cut &amp; paste rows to a new workbook based on a changing value?

    I receive a sheet each week with the data in the following format. What I have to do is select rows based on the number in col D then move those rows to a new workbook. So all the rows with 10 in the D col go into a new book, then all the rows with 12 in the D col go into another new book etc...
  3. Kelser

    How do I create an Outline Numbered TOC in Word 2007?

    In Word 2003 I used to be able to create a style - Format menu - New - name it, then click on the Format button - Numbering - then select Outline Numbering - Then when I made my Table of Contents, the Numbering was brought into the TOC at the start of the text. The option to pick Outline...
  4. Kelser

    How do extend the character length of a drop down field in word 2003?

    You are allowed to put in 25 separate items into a Word drop down field - I would like to place more than that, say 40. How do I do this? Also, the character width per line, is 50 characters, can this be extended? Many thanks
  5. Kelser

    How to put in the Average symbol in Word

    Does anyone know how to put in the Average sign - the X with the line above it - in Word (2000 or XP)? I've gone through the Insert menu and Symbol and can't find it, I've also tried Excel. Any help would be appreciated.
  6. Kelser

    How to work out the month prior to the last full month

    I am using Crystal 11. I have a date field and I need to look up the last month, which works fine using the LastFullMonth function. However, I also want to be able to see information for the month previous to that, whatever that month is. So, if I use this function today: {Book.DateIn} =...
  7. Kelser

    Upgrading from V6 to V9 causing issues when files exported to Word

    I am a Crystal Reports end user training instructor. A client I dealt with has asked for help with an issue they are having since upgrading from Crystal V6 to V9. I have tried, unsuccessfully, to recreate the problem and was wondering if any of you might know how to get around this. The...
  8. Kelser

    Crystal Reports and PDAs

    Can Crystal Reports be used on a PDA? Would there be any particular limitations? What versions could be placed on a PDA? I'm just looking for general information really. Many thanks
  9. Kelser

    Change from Date / Time to Date data type

    In Crystal Reports 8.5 you could go to the File menu - Options - Reporting tab heading and click the down arrow beside 'Convert Date-Time field:' and choose 'To Date'. This facility is not available in Crystal Reports 9.0 or 10.0. Does anyone know how to carry out that same action in versions...

Part and Inventory Search

Back
Top