>You might want to Optimize the FOR expression by indexing the table on the field 'posted'.
If "posted" has only a few values (like .T. / .F.), this will probably make the query slower, since, to "Optimize" the query, Visual FoxPro will get index information for
all records that have the specified value.
UPDATE: Oh, sorry - looking back at the original message, the information the field holds is quite different. But creating an index had been suggested already.
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)