View Single Post
  #5 (permalink)  
Old July 4th, 2003, 04:01 AM
owain owain is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Cardiff, , United Kingdom.
Posts: 231
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the advice, however I have hit another problem. The field can contain NULL values, so using CLng can raise a run-time error '94': Invalid use of Null. Just to clarify, the statement I am using is:

Code:
SELECT COUNT(*) FROM Image WHERE CLng(User1) > 0
I have tried adding the clause 'User1 IS NOT NULL' to the statement:

Code:
SELECT COUNT(*) FROM Image WHERE User1 IS NOT NULL OR CLng(User1) > 0
however the run-time error still occurs. Is there any way round this?

Regards
Owain Williams