I have created a simple employee attendance database in access. When calculating the numbers my result is negative values. I am using field name (in/out) and data type (yes/no). When performing a count on the (in) field I receive -values. Please help!!!! to resolve.
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Negative results
- Thread starter ramsc
- Start date
ChrisBelzona
Programmer
ramsc
Are you trying to Sum the total of the In's out's or count the number of times they appear?
Cheers
Chris
Are you trying to Sum the total of the In's out's or count the number of times they appear?
Cheers
Chris
CosmoKramer
Programmer
Check out Access help for the Abs function. Abs returns the absolute value of a number.
- Status
Similar threads
- Locked
- Question
