Query Not Working #2

Problem

query formulas don't work!
" I type in criteria and nothing happens!"
query formula works when blank, but not when they put their criteria into MacNail construction accounting software

Diagnosis

First make sure the Query Box works with all criteria removed (TA 115).
The most common cause of 'it's no finding what it's supposed to' is extra stray criteria that they don't notice.
If that's OK, re-enter the criteria. If multiple criteria, try one at a time. If still not working:

Solution

• Is it a date? Make sure it is a valid date! E.g. >9/31 breaks.
• It may just be that there really aren't any items matching their criteria, or something is wrong. Choose Find from Data menu to inspect each item.
• Is Calculation set to Automatic? Should be.
• Can't use ≤ or ≥, must do >= or <=

If they are doing something wacky, it may help to try entering it yourself. Have them read it off character by character, and type it into the same sheet here.

NOTE-- Goldenseal accounting software includes a Find command, which is a much simpler way to find specific business transactions.

Comments

Entered 10/11/95 by Randy. Updated 11/9/2010.