> If I have a query (a join) that returns the following columns:
>
> Address1, Address2, OtherStuff, Address1, Address2
>
> Can I still use FieldByName to extract the results, or am I forced to
> get the column by position?

If Address1 and Address1 are different, then I presume that
they have different table names?

What I think you need is to add 'AS Address3' and 'AS
Address4' after the second to so that they can actually by
accessed.

Personally I would not be using the same field name for
different data across tables in the same database, so you
would have to have a good reason for confusing yourself?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services