query expr

[mkelly]

I have an expression in a query that I want to give a value of 1 if true.
the exp is:
([targeted completion date]<[time job completed])=1

However the only thing it returns is a 0
what am I doing wrong???

 

[The_Doc_Man]

Expressions involving the relational operators ALWAYS return True or False anyway. Skip the "=1" part. By the way, True might be -1, not +1. If I remembered that correctly, then there is never a time when a relational operation returns a value of +1, so the "=1" part is guaranteed to always be False, which IS 0 for Access. (That one, I remember!)

 

[mkelly]

thanks for the help

 

[mkelly]

thanks for the help