>thanks
>
>how to store in to a variable instead of an array ?
>
>n_copy is a textbox in the form
Instead of selecting into an array, you can also
select ... to screen noconsole
(without a group by clause, or a count clause).
In either case, _tally gives you the number of records counted.
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)