Home → Queries
Ad Hoc Queries
Use the Progress "Procedure Editor" to generate ad hoc queries to create specialized reports.
Manual:
- Download the Basic Query Course Training Manual, updated May 2005 (RTF)(Word)
- Download the Training Manual Exercises & Solutions (RTF)(Word)
WIN-202 Table Listing (HTML)(Word)
- ADMIN Table Format (HTML)(Excel)
- QUARTERLY Table Format (HTML)(Excel)
- Control-File Table Format (HTML)(Excel)
- Macnaics Table Format (HTML)(Excel)
Queries:
- Lists manually marked records to be included on the Subset EQUI (subset.p) (posted 11-19-07)
- Lists master accounts with prorated subunits (mastersWithProratedSubs.p) (posted 5-30-07)
- Estimated accounts for comparison against your tax extract (estimated-records.p) (posted 8-1-06)
- ARCS control file accounts with no response (ARCS_non-response.p) (posted 7-18-06)
- Current year/quarter accounts with "A" indicators (a-acct.p) (posted 5-23-06)