>thank you, Hilmar, but this not resolve problem !!!!
SELECT invoices.*,invdet.*,invdet.td as to
Since "to" is a reserved word, it may cause trouble.
Also, check the value of the form property which you use as part of the condition.
If this doesn't work, post the new version of the SELECT command, to continue the investigations.
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)