
July 2nd, 2004, 09:15 PM
|
|
Registered User
|
|
Join Date: Jun 2004
Location: Singapore
Posts: 28
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Sum statement
I got value1 - value10 fields. Each field only contain 1 0r 0 and the datatype of the fields is number.
However everytime i add in a new record, only one field is 1 and the rest of the 9 fields is 0.
But there is no validation to control user to stick to my idea as some user will still add a record with 2 one.
Therefore i need to check which record is having more than one 1.
What is the statement that i can use? Can Sum statement be use?
|