AnsweredAssumed Answered

How do I "sort" or "find" to locate records that have entries in just two fields?

Question asked by Sam2 on Feb 7, 2014
Latest reply on Feb 7, 2014 by philmodjunk

Title

How do I "sort" or "find" to locate records that have entries in just two fields?

Post

     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...

     Thank you!

database.jpg

Outcomes