Re: databases

You can

    iterate throught the querydefs collection,     grab tthe SQL property for each querydef     parse the SQL
    Test the Parsed SQl
    Add the field if it passes the tests     Write the SQl back to the Querydef object.

<tanoa_at_my-deja.com> wrote in message news:8jaeti$vt3$1_at_nnrp2.deja.com...
> I am using ms-access. I have created several fields in the 'tables' data
> sheet and have created several hundred queries from that data.
 Subsequently I
> have added another field to the original table of information and I would
> also like to add this to my queries. Will this involve changing each query
> individually?, If not can you advise me of a way I can make this field
> available on all my queries without having to do this individually? Many
> Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jun 28 2000 - 00:00:00 CEST