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)

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)

Query Examples (6KB ZIP)