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 Westi 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: sanjaych
  • Order by date
  1. sanjaych

    How do you display Latest Status only?

    I have a report where the same companies are showing multiple times as they have multiple status next to them. e.g XYZ Ltd - Status Initiation XYZ Ltd - Status Launched XYZ Ltd - Status Post Launch I only want the record XYZ Ltd - Status Post Launch to show on the report. I can...
  2. sanjaych

    I only want to show records that have null in a date time field

    I only want to show records that have null in a date time field. What formula should I use?
  3. sanjaych

    Supresing the word False from report results

    I have sorted it - Madawc's formula worked, I was applyinhg the formula via the selection editor which is why it was not working for me. When i add a formula field to the report the formula works fine. All sorted thanks.
  4. sanjaych

    Supresing the word False from report results

    If it is a string value will your formula change?
  5. sanjaych

    Supresing the word False from report results

    I have a report that is returning True and False values from a tick box field within the database. I only want the report to display the true values. The problem is that I have 12 tick boxes in a row and I can't get the formula correct in selection editor without skewing the report results.
  6. sanjaych

    How do you supress a row of data when a date is not present in my data

    I am trying to supress a row of data but only when a blank value is returned in a report field. Is there a formula for this or somr conditional formating?
  7. sanjaych

    Display unique date

    Can you help to explain what is meant by table.date and table.activity?
  8. sanjaych

    Display unique date

    I have some company names in my report with dates showing next to activity. How do you only show the most recent date of activity?

Part and Inventory Search

Back
Top