Once you have completed these steps, you are ready to create a database
query. For example, suppose we have am MS Access table called Users.MDB
which contains a table Users with the following information:
The query syntax for retrieving all the table data is:
SELECT * FROM USERS
where "USERS" is a table in the Users.mdb database file.
Since the query can be considerably more complex than the one for this
example, we would advise you to construct the query in MS Access until
you are absolutely certain that your query returns the required result.
If this is the case, then copy the SQL query into UMRA as follows:
1. Select the Query tab in the
Setup generic table dialog box
2. Paste the query into the Database
query window.
3. Click the Run test tab and
click the Test... button to check
once more if the query is working correctly.
