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 Rhinorhino 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: rmarcus
  • Content: Threads
  • Order by date
  1. rmarcus

    Excel 2016 Pivot Table Date Format

    I have a file which has a date (dd/mm/yyyy)against a document reference. When I create a pivot table with the document number and date column it automatically adds "Quarter" and "Year" although the data table does not have columns headed "Quarter" and "Year". The pivot table shows the column...
  2. rmarcus

    Outlook 2010 Meeting Request issue

    In some cases a user (Outlook 2010) sending a meeting request finds that the recipient only receives the request as an e mail with only the subject showing. No meeting details or accept buttons appear. This generally happens when the request is sent to a German address. When sending to a...
  3. rmarcus

    Spam - Content Scanning

    The Enterprise edition includes content scanning for spam but with Exchange 5.5 the gateway will only look at the subject line and not into the body of the e mail. Has anyone found a work around to scan the body for spam ? Regards Ralph
  4. rmarcus

    If then statement

    I have a formula which has a number of If then conditions. If a particular condition exist, I want the report to print a blank space. Can I do this in V7 ? I have tried using "" but it says a number is required. Thanks Ralph
  5. rmarcus

    Excel - Pivot Table

    I have a pivot table which sums the QTY and VALUE in the data field. Is there any way I can get it to show the sum in columns instead of two rows ? Ralph
  6. rmarcus

    Month to Date/Year to Date in same report

    I am using CR7 and have a table which details sales info by Doc ref. Each record shows Stock No, units sold, sales value and cost value. Is there a way I can sumarize to show in one line the Stock No, Units Sold, Sales Value and Cost Value for Month to Date and Year to Date without having to...
  7. rmarcus

    Printing blank pages in landscape

    Any report in Landscape prints a blank page after every printed page. (HP Laserjets) If I set it to Portrait, it prints two pages with print only. I have tried changing margins with no success. The same report printed from C7 report designer prints correctly. When printing to a Lexmark it prints...

Part and Inventory Search

Back
Top