How do I "sort" or "find" to locate records that have entries in just two fields?
I have a database with several columns. Not all of the columns have an entry. Some of them are jpeg images and some of them contain text. I need to learn how to do a "sort" or a "find" to show only the records that have entries in 2 of the columns- one of which is text and the other is a jpeg image. I know how to do a find where I put an asterisk in the text column which works great, but I can't enter an asterisk in the image column...it won't let me.
I would also like to know how to do the same thing but find records that have an image but NOT the description and visa versa.
i am attaching an image to show you what I mean...