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 Mike Lewis 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. SgtDan

    CR XI group sort by Last Name

    Thank you for a quick and helpful response
  2. SgtDan

    CR XI group sort by Last Name

    I have three groups, first by assignment of the employee. Second by 'Last Name', and third by a log number assigned to the employee. Sorting group of 'Last Name' ascending, seperates alpha and the records by quantity of assigned logs. i.e. General Services Jones 12345 12346 Adams 12476...
  3. SgtDan

    At least one record in detail group must match

    Thanks dtempleton and lbass, problem resolved.
  4. SgtDan

    At least one record in detail group must match

    Sorry, just remembered.. I also filter my group records by those in the group having ten or more incidents.
  5. SgtDan

    At least one record in detail group must match

    That was my first thought but there was no ability to "select" on my formula field because the select expert doesn't show or allow the formula to select records
  6. SgtDan

    At least one record in detail group must match

    I am using Crystal 8. The need is to only display records from a selection group band that have at least one record in detail band that is less than an arbitrary date i.e. "1/1/2002". I created a formula field for max date in the group but I'm having a problem in where to place a formula...
  7. SgtDan

    trailing zero's in formula

    To correct address numbers or any number as you described, I use the formula - ToText({Table.StreetNumber},0,"")
  8. SgtDan

    Auto Increment Duplicate Numbers

    I have a master table with two dependent tables. The master table is keyed on three fields and was working fine up to 145 records when the autoincrement stopped. The numbering system started adding dupe numbers which was allowed because of the additional keyed fields were different. What...

Part and Inventory Search

Back
Top