Query Image (int)

B

Ben Adams

Want to query weather an image is null. But IsNull() doesn't work with an
int. How can I check via a query what records don't have an image? Help...pls
 
S

Sylvain Lafontaine

Sorry, but I absolutely don't understand your question. First, you should
make sure that you are on the right newsgroup; ie., you are working with an
Access ADP project against a SQL-Server and you are not using a MDB or and
ACCDB file with ODBC linked tables or using .NET.

Second, you should provide some examples of code that you have tried with
the IsNULL() function as well as some basic informations about the tables
that you are using and the versions of the platforms. Also, take the time
to explain why you speak at the same time about both an image type and an
integer (int) type. Finally, IsNull() should work pretty well with an int.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top