making count a boolean 1

[jmodo]

(Select Count(*) from [A] where idA = [A].idA and [A].idB=.idB)

I would like this to return true/false, instead of a number. All I can figure out is how to format it.

Thanks,
J

 

[PHV]

Use the CBool function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886