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 TouchToneTommy 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. LauraW

    Format Numbers in a String

    Hi Pete, Unfortunately it happens with every record where we use that particular field. I may have to back into it this way. IF NOT(isnumeric({PERSACTION.NEW_VALUE_11})) = TRUE THEN ".000001" ELSE "CHECK" (or) IF {PERSACTION.NEW_VALUE_11} = "1.00" THEN "ERROR" ELSE "OK" I will have to test...
  2. LauraW

    Format Numbers in a String

    Thanks Pete! That returned a whole number of 1.00 even though the field was entered as .000001 (which is what is required) We are using the Lawson/Infor ERP system and we use Crystal Reports as our reporting software. We try to validate the data before releasing into our live system and the...
  3. 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...
  4. LauraW

    Filtering on a Group Footer?

    HOORAY! That worked. Thank you so much! Have a wonderful day [bigsmile] Laura~
  5. 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...
  6. LauraW

    Summing Time worked and manually entered Hours in Excel

    Hi Skip Sorry about the lack of info: =SUM(Q23:Z23)+(M23*24) Q23:Z23 are summed the manually entered hours for sick, vacation and personal time etc. M23 is the total calculated hours from the times in and out. Laura~
  7. LauraW

    Summing Time worked and manually entered Hours in Excel

    I figured it out. I knew is was something simple. =SUM(Q23:Z23)+(M23*24) Sum of manual hours entered + calculated time * 24. Have a great day everyone!
  8. 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...
  9. LauraW

    Leading Spaces in Access Database

    Good Lord no - she doesn't enter anything directly into the table. I make all my users do their data entry via forms (not even datasheets) and I've hidden the navigation pane so they can't get to the tables, macros, etc. I've written code so that if they try to save a record without the...
  10. LauraW

    Vanishing data

    I've had a similar problem with a field - but just the opposite of your issue. When text is entered (you see the cursor moving) but it doesn't show up until I move to the next field. This happens on every computer so I know it's not a hardware issue. Laura~
  11. LauraW

    Leading Spaces in Access Database

    Trust me I would if I could get her to replicate what she did. I just get "I don't know. I did what you told me!" [tongue][pc2]
  12. LauraW

    Leading Spaces in Access Database

    Hi Andy, I usually fix them because they are completely missing first names or last names because the fields are left completely blank because they use spaces. I play Sherlock Holmes and figure out whose record it is by the other fields. When I ask them to fix it, it makes matters worse...
  13. LauraW

    Leading Spaces in Access Database

    I've tried correcting the user error until I was blue in the face. I get the "deer caught in the headlights" look and end up correcting all the records myself (which is very annoying to say the least lol). Thanks for your help everyone. I will make sure to eliminate both leading AND trailing...
  14. LauraW

    Leading Spaces in Access Database

    Not like " *" worked. Thank you!! Laura~
  15. 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...
  16. LauraW

    Access Validation Rule - Leading Spaces

    Opps sorry.... wrong forum - lack of coffee this morning!. I will repost in the Access area! Laura~
  17. 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...
  18. LauraW

    Sum If Statement?

    Ok - I think I figured it out. I have to create a group and then do a sum via a running total. I would have thought there would have been an easier way!
  19. 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...

Part and Inventory Search

Back
Top