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 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: *

  1. kwirky

    IF merge field in Word 2010

    Thank you so much. That has worked perfectly!
  2. kwirky

    IF merge field in Word 2010

    ...the form of Pty Ltd, Pty. Ltd. and P/L What is the syntax for using an IF OR statement? I think the one I figured out is an AND statement (where all three conditions must be met). {IF {<<Offender>>}= "*PTY. LTD." IF {<<Offender>>}= "*PTY LTD" IF {<<Offender>>}= "*P/L" "" {<<Offender>>}} Thanks
  3. kwirky

    IF merge field in Word 2010

    That was perfect! Thank you.
  4. kwirky

    IF merge field in Word 2010

    ...teh following formatting I am still seeing all the results, and this includes those where the offender name contains "Pty". {IF {<<Offender>>} = "*pty*" "" {Offender}} What I would like to see is that if any Offender has a Pty at the end of their name, then they are considered a Company...
  5. kwirky

    IF merge field in Word 2010

    ...If the {offender} is not a company, then use the {offender} details. I have started with the following however when I merge the document, I am still seeing results with PTY LTD at the end. {IF{Offender}={"*PTY LTD"} "" {Offender}} What am I doing wrong? Any help would be appreciated. Thanks
  6. kwirky

    Selecting records which have two fields NULL or empty

    Thank you so much for your help. I used George's Where Text16 > '' And Text17 > '' and it worked beautifully.
  7. kwirky

    Selecting records which have two fields NULL or empty

    Hi, I am trying to create a select query which will show me only the records which have a value in 2 fields. I have tried the below and it seems to work okay except that i am still getting some records which have an 'empty' Text17. In the example below I do not expect to see the 2nd and 3rd...
  8. kwirky

    Importing CSV into Visio 2003/2007

    Hello, I am hoping someone can help with a code or similar to import csv files into Visio 2003/2007 (we have both). We have a document management system (DMS) which has a workflow engine. Long story short we need to get these workflows out of the ECM and process mapped in preparation for a new...
  9. kwirky

    It and formula

    I wasn't getting anything at all. I retested it and found that there is actually a space before WW which I couldn't see. I copied the data directly from the table and then found the space. I then amended the "WW" to be " WW" and it works fine. Thanks for your time :)
  10. kwirky

    It and formula

    ...which I want to identify which ones contain 2 specific values. my formula is as follows: if {Jobs.Site} = "WW" and {Jobs.CustomerName} like "ABC*" then "Accept" So within my Jobs table, I have two things I want the report to look for and if they BOTH match, to use that result. It cannot...
  11. kwirky

    Automatically add username

    Thank you. I tried the SQL expression and it worked beautifully :)
  12. kwirky

    Automatically add username

    Hi, Is there any way to create a field etc to allow the name of the user who printed the document to show? For instance Report Printed by: {@username} We create the reports through CR 2008 and they are run by end users on terminals (they log into the terminals using AD) through an MIS. We...
  13. kwirky

    Crystal Reports 2008, Crystal Server 2008 &amp; repository

    Thanks guys. That helps heaps. I will now be able to do some research and speak with confidence.
  14. kwirky

    Crystal Reports 2008, Crystal Server 2008 &amp; repository

    Hello, We are currently using CR Server 2008 to schedule reports that are created in CR 2008. All working fine from that perspective. One of the finance guys has asked about the repository and saving data in there which can be used with various reports (from what I can tell, he believes that...
  15. kwirky

    Crystal Server 2008 - updating reports

    Hello, We are currently using CR 2008 as well as Crystal Server 2008. One thing we have found is that CS is fiddly when it comes to updating existing reports. The process we are currently following is as follows: 1. Develop report in CR 2008 on separate server. 2. Log into Crystal Server and...
  16. kwirky

    If And Statement

    Worked perfectly. Thank you
  17. kwirky

    If And Statement

    I went another way with this which kind of sorted my problem. I grouped by job number and then used the maximum of the journal entries (based on date) to give me the most recent description. Because there are many types of journal entries, I used a formula if ({Journals.Description}) =...
  18. kwirky

    If And Statement

    ...not need to appear on the report. I thought I could have something like @Restarted if {@On Hold} = "On Hold" and if {Journals.Description} like "*In Progress" then "restart" However I think my syntax is out as I get an error "The keyword 'then' is missing" What is the proper syntax...

Part and Inventory Search

Back
Top