>>I think both are proper.
>>
>>You can also:
>>
>>update MyTable;
>> set reprints = reprints + 1, flagged = "O";
>> where flagged = "P"
>>
>>This will automatically open, but not close, the table.
>
>The table is already open in this case.
>Thanks for the guidance. I have not dabbled with SQL stuff much, but I see it is quite powerful.
Powerful, indeed. If you haven't done so, I strongly suggest you take a look at the SELECT - SQL command; this is very useful as a first step to reporting.
I wrote an introductory article about SQL commands, available at
http://www.levelextreme.com/Magazine/April2002/Page3.asp.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)