Help with advise on finding fields with values

[Ron P]

I use filemaker as my database from which I sell business leads. I have one client who only wants businesses in a particular SIC code who also has a fax number. I have many fields per record including SIC code and Fax number. I am hoping that someone can tell me a simple way without using scripts which I've never done, how to do these in find mode. I realize to enter the SIC Code in the SIC Code field, but I have no idea of what to enter into the fax field. I've tried "=", and "==" as well as "=" with the omit button checked, but none of those work. There hast to be an easy way to say give me this SIC code, but only with there is a value in the fax field. Your help would be most appreciated!!!

Thanks

Ron Parker

[email protected]

[MoonShadow]

"but only with there is a value in the fax field"

Enter * in the fax field. I assume it is a text field? This will find SIC matches whose fax entries aren't blank. If a number field, try > 0. And don't put quotes around it.

[RalphL]

Enter the SIC code in its field. Do a new request. Enter the equal sign = in the fax number and check the Omit box. This should work.

[Ron P]

Thanks for the tips!!!

Mission accomplished.

I love this forum.

Ron