Adding new queries to the database involves the following steps:
1. Open the back-end database file
C:\Program Files\CRIS\<XXXX>\CRIS_<XXXX>.mdb
2. Go to the Queries tab on the Database window.
3. Click on the New button.
4. Select Design View in the New Query window and click on OK.
5. Create a query of any type, e.g.
cross-tab query (for example, for analysis purposes),
action query to add data to tables (for example, for a customized data import function), or
action query to delete data from tables (for example, to create an install with only one project’s data).
Care should be taken when saving a new query to choose an appropriate name. Queries that are intended to be available on the Configure Report or Configure Query screens should be saved using a name not beginning with an ‘_’ (underscore) or ‘~’ (tilde) character, as these are reserved for queries used internally by CRIS and internally by Access, respectively. It is recommended that action queries not appropriate for use for outputting should have a name beginning with an ‘_’ (underscore) character.
Topics Steps System Manual Home CPACC Home
Questions or problems regarding this web
site should be directed to [email protected].
Last modified: July 13, 2001