(Abs) Stripping the negative sign

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

# Chronic Conditions:
[IDDM]+[NIDDM]+[HIV]+[Resp]+[Asthma]+[Hyperlipidemia]+[Cardiac]+[Seizure]+[HTN]+[Hep
C Pos]+[HBV]. I placed the following statement in a select query to count the
number of boxes that are checked. Everything works fine except the results
are shown as a negative number. I'm not sure how to use the Abs function in
this situation. Any help would be greatly appreciated.

Jon
 
Abs([IDDM]+[NIDDM]+[HIV]+[Resp]+[Asthma]+[Hyperlipidemia]+[Cardiac]+[Seizure]+[HTN]+[Hep
C Pos]+[HBV])
 
Thanks

It worked

Douglas J. Steele said:
Abs([IDDM]+[NIDDM]+[HIV]+[Resp]+[Asthma]+[Hyperlipidemia]+[Cardiac]+[Seizure]+[HTN]+[Hep
C Pos]+[HBV])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Jon said:
# Chronic Conditions:
[IDDM]+[NIDDM]+[HIV]+[Resp]+[Asthma]+[Hyperlipidemia]+[Cardiac]+[Seizure]+[HTN]+[Hep
C Pos]+[HBV]. I placed the following statement in a select query to count
the
number of boxes that are checked. Everything works fine except the results
are shown as a negative number. I'm not sure how to use the Abs function
in
this situation. Any help would be greatly appreciated.

Jon
 
Back
Top