Hi Gerard,

I don't know that it's a bug, but I did stumble on that same behaviour a couple months ago. See:
[Databases,Tables, Views, Indexing and SQL syntax] Select from a local view Thread #259932 Message #259932 date: 31/08/1999.

John Kozoil came up with the COPY TO ARRAY solution.

>>>>This will work if the view is row buffered as long as you do a tableupdate on your current record. This may not feasible for what you are doing.
>Dan><<<
>
>Dan, unfortunately, it is not feasible.
>
>This surely must be a Bug, in that a straight Copy give different results to s Sql Select... would you agree and how does one go about getting bugs fixed by Microsoft ?
>
>Regards,
>
>Gerard