General Tips and Information What's New In Q&A Version 4.0 (5 pages) 2001 Considerations in Database Design (3 Pages) 2002 Copying Your Database (1 page) 2003 Re-indexing Your Database (1 page) 2004 Rebuilding Your Database (1 page) 2005 Producing a Backup of Your Database (2 pages) 2006 Recovering Your Database (1 page) 2007 File Not Properly Closed (2 pages) 2008 Recovering Index File Problems (5 pages) 2009 Tips on Using Custom Menus (8 pages) 2011 Running Q&A 4.0 Under Windows 3.x (1 page) 2012 Tips on Optimizing speed in Q&A 4.0 (3 pages) 2013 Reinstalling Your Program Disks (1 page) 2014 Handling Temporary Files (1 page) 2015 Information regarding Premium Support (2 pages) 2016 Q&A third party book list (1 page) 2017 File/Programming/Mass Update Building a Full Name from Component Parts (1 page) 2101 Using the Sequential Numbering Feature (2 pages) 2102 Staying in Insert Mode in Search/Update (1 page) 2103 Making Room to Teach the IA (1 page) 2104 Separating Whole Name Fields (1 page) 2105 Moving Information from a Database into a Lookup Table (3 pages) 2106 Separating a Two-Line Field into Two Fields (1 page) 2107 Marking/Removing Duplicate Records in a Q&A Database (1 page) 2108 Consolidating a Mailing List (2 pages) 2110 Troubleshooting Programming Statements 2111 Creating a Unique Number with a Prefix (1 page) 2112 Manipulating Date Fields with String Functions (1 page) 2113 Using the Financial Features (3 pages) 2114 Date/Time Arithmetic (1 page) 2115 Calculate Present Age from Birth Date (1 page) 2116 Formatting a Phone Number Field (1 page) 2117 Marking Every Nth Record (1 page) 2118 Looking Up Multiple Values for a Keyword Field (1 page) 2119 Search / Replace Carriage Returns in a Field (1 page) 2120 Using Programming Statements in the Retrieve Spec 2121 Report/Derived Columns Keeping a Running Total (2 pages) 2201 Finding the Latest Date from Multiple Date Fields 2202 Counting the Number of Different Entries in a Field (1 page) 2203 Counting the Number of Records per Entry in a File (1 page) 2204 Recreating a Report Spec (1 page) 2205 Underlining Blank Fields in Report (1 page) 2206 Sort by Day of the Year (1 page) 2207 @XLookup with Report Derived Columns (2 pages) 2208 Reports with Multiple Fields in One Column (1 page) 2209 Controlling Page Breaks in a Report (1 page) 2210 Reporting Differences Between Databases (2 pages) 2211 Conditional Printing in Report (2 pages) 2212 Summary Reports (5 pages) 2213 All About Cumulative Derived Columns (2 pages) 2214 Number the Lines of a Report (1 page) 2215 Write/Mailing Labels Make All Carriage Returns Visible in Write in 3.0 (1 page) 2301 Envelope Document for Q&A/Q&A Write for 3.0 (1 page) 2302 Copying Large Blocks of Text to Another Document (1 page) 2303 Conditional Printing in Q&A Write (1 page) 2304 Printing Multiple Copies of One Label in 3.0 (1 page) 2305 Using Write to Produce a Report - Like Document (1 page) 2306 Utilities and DOS Tips Creating Font Files with QAFONT.EXE for 3.0 (2 pages) 2401 QASpec v1.0 (2 pages) 2402 Changing Case with QACASE.EXE Program for 3.0 (2 pages) 2403 Fun with Special Characters (1 page) 2404 Types of ASCII Files (2 pages) 2405 DOS Tips (4 pages) 2406 Sending Postfiles to a Postscript Printer (1 page) 2407