I have a database which have several tables and some of the tables have same field names. For example, I have field call "name" in both Customer table and Vendor table.

I have one query which join those two tables together. I like to print out both name in customer and vendor table.

BUT
RS.Fields("Customer.name").Value
RS.Fields("Vendor.name").value

both statement gave me not found in record. It is perfect fine in access. I don't know if it different way of calling each field

Please help

Hi there,

Column names for the recordset should be unique, and unfortunately, you can't use the Table name prefix in the Recordset syntax as you found out. What you can do is alias your column names, and use that alias to retrieve the value:

SELECT Customer.Name AS CustomerName, Vendor.Name AS VendorName, Bla bla bla

Now, in your recordset, you can use CustomerName and VendorName like this:

RS.Fields("Customername").Value
RS.Fields("Vendorname").value


HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.