ah i see how this works now - within the query, pressing sql translates the query into code. i would not have found this one on my own. thanks for the tip Hilmar - that is going to be great help. k


>>tnx i will definitely look into that and use your code as model. sounds great! k
>
>I understand you are not very familiar with the SELECT - SQL command. The options can be a little confusing at first; for a start, you can issue the command CREATE QUERY. In the query designer, select some tables and fields, plus the conditions for joining tables if you need more than one table, and then look at the generated code, which you might copy to a program.
>
>This is not a replacement for a thorough understanding of this command, but it is a convenient starting point.