Open topic with navigation

> Utilities / Database Utilities / Exporting Expenses using Query Analyser

Query Analyser

The Query Analyser utility enables you to set up database queries using the SQL language.

You can use it, for example, to export expenses to Sage 50.

Sage Coretime does not allow you to actually make changes to the database using SQL.
  1. Open the Utilities view in the left-hand pane.
  2. Click the Database Utilities in the left-hand pane.
  3. Click Query Analyser in the left-hand pane.
  4. In the main workspace, use the main pane to enter ADD a new query or EDIT existing ones.
  5. Click SUBMIT QUERY to save your changes.

The following web site is a useful source of information on creating SQL database queries:

www.w3schools.com/sql/default.asp

See also

Database Utilities

Go to top