Click to See Complete Forum and Search --> : Problem with 0x800A0CC1


sirvolt_98
October 13th, 2003, 07:13 AM
Having trouble with this error --0x800A0CC1 Item cannot be found in the collection corresponding to the requested name or ordinal.Eventhough the fields I am trying to access is already in the Access Dbase. All the field names are the same, here's my select statement,

Select BillFirstName, BillLastName, BillAddress, " _
& "BillCity, BillState, BillZip, ShipFirstName, ShipLastName, ShipAddress, " _
& "ShipCity, ShipState, ShipZip From Customers Where CustomerID =" & Session("CustomerID")

Problem is in this line------> <% Response.Write RSCustomer("BillFirstName") %>

Any help will be appreciated, Thanks in advance