Query Formulas

Problem

query formulas don't work!
OR
" I type in criteria and nothing happens!"

Diagnosis

Are the boxes for 'most recent payout', 'total amount paid' etc blank?

YES-- choose *Query Formulas from the Formulas menu, and click "OK"
when it asks "Restore all database formulas". Then it should work.

NO-- see below

Solution

1. First clear the Criteria and make sure it works then. Click in each criteria cell and hit the 'delete' key on the keyboard. If #'s appear after that, they've fixed the problem (95% of the time this fixes it). Then try re-entering the criteria-- if it breaks now, something is wrong with their data entry (see TA 518)
2. Make sure it's set to Automatic Calculation in MacNail construction accounting software
3. If it STILL doesn't work, try doing Options\*Fix Database.
4. Try doing *Query Formulas again
5. If still broken, repeat step 1 making absolutely sure they're really clearing the right cells (have them describe the exact cells, read off titles etc so there's no confusion). Can also have them select all the blank cells, unprotect document, choose clear from Edit menu.
6. If all those don't fix it, they should either send us the file or we'll have to check location of defined names etc-- a very tedious process. Can also have them copy/paste data into a new worksheet of the same type.

NOTE-- Goldenseal construction accounting software replaces MacNail, and has a much simpler Find command that gives you access to any records you need to see.

Comments

Entered 11/25/92 by Vinay. Updated 11/9/2010.