(Desperate) How to Qry on the Fields that an Image is there?????

  • Thread starter Thread starter Ron Cordoba
  • Start date Start date
R

Ron Cordoba

Hi,

I need help in the following:

I have created a table linked from excel which I added a field containing
photos. The extra field created is called 'Product" and the data type is
"OLE Object"

I then brought an image in and it listed as Paint Shop Pro Image on the
field, no problems there...

I created a qry only showing the categories and I can see the photo as I
scroll through all the records with the same category, but my problem is I
don't know how to list only the records with the image on it...

Why? I may have up to 200 products on the same category but only need to
display...let's say 20 as these have images....

Does anyone know how to make this happen???? I have tried everyewhere to no
avail untill directed to this news group...

Please help :)

Thank you

Ron
 
Thanks guys... I panicked a bit, all I needed to do is to enter True on the
qry field and I got the result that I was after....

Thanks

Ron
 
Back
Top