problem with sql statement

[zambam]

i have written this:

SELECT `Member ID`, Forename, Surname, `Paid?`, `Fine?`,
`Amount Due`
FROM `WHO HAVE NOT PAID`
WHERE (`Paid?` = 0) AND (`Fine?` = 1)

this is supposed to show people who have not yet paid, but it does not bring up anything in the search now. it used to work before...

whats wrong??

 

[Alc]

If 'Paid?' and 'Fine?' are boolean, would

'Paid?' = 0 and 'Fine?' = -1

work?

 

[KeithG]

Are you writing this SQl in a module? Or the query designer?

 

[zambam]

If 'Paid?' and 'Fine?' are boolean, would

'Paid?' = 0 and 'Fine?' = -1

work?

WOHOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO


I CAHNGED THE "1" TO "-1" AND IT WORKED!!!! THANK U SOOOOOOOOOOOOOOOOOO MUCH!!

(sry abt caps - im just so happy now!)

thanks again!!!!

 

[Alc]

Glad to help and thanks for letting me know it worked.