Special Query Searches

Problem

query box- special types of searches, looking for blanks, non-blanks, and other unusual things. How to use MacNail construction accounting software for finding and extracting blanks etc

Diagnosis

(see also item 126). Here are some tricks on using the query box:

Solution

type = into a column will find all blank entries in that column
type <> will find non-blank entries
type ="=a" will find all entries in that column that exactly match the letter a (or whatever letter(s) you type in). Note that typing just an "a" will find all entries in that column CONTAINING the letter a.

NOTE-- Goldenseal accounting software offers a much better system for finding accounting records!

Comments

Entered 12/24/92 by Vinay. Updated 11/10/2010.