Ashley,

>This is probably simple and obvious, but I get syntax errors trying to formulate the SQL statement.
>I would like to extract only the records from a table that are DISTINCT in every field into another table.

Maybe if you post the SQL we can help you find the error.

This ought to do what you want:

select distinct * ;
   from TheTable ;
   into table TheDistinctTable

>Another one is: How do I query just 1 record using SQL? I just want to create a table which echoes the structure of the database being queried (Yes, I could zap the result, but that sems the ugly way to do it).

select * ;
   from TheTable ;
   into table TheTableStructure ;
   where 1=2