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

    String Field to Date in 8.5

    I have the following string field (that is a user defined field) and is inputted to the program as 06/23/97 I need to convert this string field to a date field in CR 8.5 this is the format in the db +000019970623000000 any help on how the formula should be, as I keep getting an...
  2. prl423

    A value greater or less than 0

    When my OTPay field indicates a value < or > than 0, and when but when there is actually an OT value, $550.00 I would like to show the PayName field to display OT....instead of regular... the formula goes something like this: if {tblEmpeHours.OTPay} is <> 0 then {tblEmpeHours.PayName} = "OT"...
  3. prl423

    Existing form to DB file.

    I have a 2006 access database that I have "saved as" a new 2007 database. I have stripped out certain data in the 2007 database, and I want to use the existing "form" and have this form populate the 2007 database. Is this even possible, or do I have to create a new form or completely new...
  4. prl423

    String to (814) 555-1212

    How do I convert the string to a phone format. Example is ..... 8145551212 to (814) 555-1212 Thanks in Advance...Using crystal 8.5 SQL DB
  5. prl423

    Printing Order

    Does anyone know why when I print a report (open order report for example) that on one day it prints items on the report: item a, then item b, then item c, and then the very next day when I print the same report again with "no" changes to any items on the report, it prints item b first, then...
  6. prl423

    Percentages on Group Sums

    I am wanting to do a percentage on sums in a group. I have multiple groups, that have sums (subtotals) within those groups. Right now I only have percentages at the end of my report. Example: Sum ({ARCUSFIL_SQL.amt_age_prd_1}) % Sum ({ARCUSFIL_SQL.balance}) How do I tell Crystal 8.5 I want...

Part and Inventory Search

Back
Top