It is really a nightmare. I have spent three weeks trying to get this complicated set of 5 access databases, 55 queries, etc to work when I could have done it in VFP in a matter of days.

Brenda


>Brenda,
>
>I think that's stretching the envelope a little. Can you do it as an SQL >query to get the data into VFP, then process it as above and do an SQL >Update back into Access?
>
>Wish you luck,