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

  • Users: LauraW
  • Content: Threads
  • Order by date
  1. LauraW

    Format Numbers in a String

    We are using Crystal to pull information out of our ERP system. I have a field that is used during data entry and is entered as .000001 However, when I pull the field into Crystal it is showing as 0000000000000001+ The field type is string Length is 60 I am trying to format the data entry...
  2. LauraW

    Filtering on a Group Footer?

    Hi Everyone, We have an employee database whereby occasionally employees have more than one {EMPLOYEE] number (each number is a separate and distinct number). Using their {FICA_NBR} as the common denominator, I created a group footer that gives me a total count of the employee's records...
  3. LauraW

    Summing Time worked and manually entered Hours in Excel

    Hi - I have a timesheet that calculates the time in and out and totals the hours worked (formatted as [hh]:mm). There are also fields where an employee will put in whole numbers for hours (i.e. 3 hours personal, 4 hours vacation, etc.) that are formatted as a number. I need to total the...
  4. LauraW

    Leading Spaces in Access Database

    Good Morning, I have an access database that multiple users do data entry intro. I have both first and last name fields that are required. However, I am getting "blanks" in that fields because they are using the space bar and access considers that a character. Is there a validation rule that...
  5. LauraW

    Access Validation Rule - Leading Spaces

    Good Morning, I have an access database that multiple users do data entry intro. I have both first and last name fields that are required. However, I am getting "blanks" in that fields because they are using the space bar and access considers that a character. Is there a validation rule that...
  6. LauraW

    Sum If Statement?

    I have a report that I need to group information by pay codes and sum the information as a total. For example: Employee X works all 4 quarters of 2015. He has OT hours in each quarter with a pay amount associated with it. I can't seem to get it to work. What am I doing wrong? if...
  7. LauraW

    Leading 0 and +

    Hi, I have a field that is a text field that needs to be formatted as a decimal. It's a pay rate field that can either be formatted like $12.50 or $32,000 depending on if the rate is hourly or salary. When bringing the field (string) in straight from my database the field shows as follows...

Part and Inventory Search

Back
Top