View Single Post
  #6 (permalink)  
Old July 4th, 2003, 04:26 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

I have found a solution. Because the field is a text field that can contain Null values, and I am only interested in the fields that contain a number I am using the following SQL statement:

SELECT COUNT(*) FROM Image WHERE Val(User1 & "") > 0
So a Null length string is concatenated to the field to eliminate any Null values, then it is Val'ed to produce a number.

Owain Williams