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...
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...
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...
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...
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~
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!
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...
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...
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~
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...
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...
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...
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...
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!
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.