Thanks Sukesh, it works fine. However (there's alsways something),
when the query is run [ Set rs = Conn.Execute(Query) ], the field gets
replaced by the fields from the query.
So I'm back where I started from - I have two database files that
have tables that I need to get information, it has to be ADO to use MS's
report facility, and no way in heck to do it!
[Ranting starts here] I just can't believe that this problem is so
uncommon that ADO has no way to do it. Surley there are applications
that pull data from tables on the corp. mainframe, the local server, and
somewhere else. The answer (in my case) is the heck with normalization
- put the same data in all tables so I can get it back again! [Ranting
done - have a nice day]
> Hello Dennis
> rs.Fields.Append "SomeName", adChar, 40
> > Since it seems impossible to query two database files with one query,
> > I'm ok with two queries and two recordsets. The problem now is that I
> > need to add a field to the ADO recordset (has to be ADO for the report
> > facility) to contain a 40 char, name, which gets filled in with my
> > look-up proc. I see there is a <rs>.Fields.Append method, but I get
> > argument agreement errors. Anyone have an example of how to use this
> > method, or a better idea?
> > Thanks,
> > Dennis