CRAP!<BR><BR>This brilliant DB designer named their fields<BR><BR>S&H and "End Bid" YES with a space!!!! YES WITH AN AMPERSAND!!!<BR><BR>How am I supposed to call these tables from VBScript?
SELECT Title,QTY,'End Bid' AS EndBid,'S&H' AS Shipping FROM....<BR><BR>Using aliases just makes it easier to reference later on.
That's aliasing the words 'End Bid' to EndBid not the value. Try this:<BR><BR>SELECT Title,QTY,[End Bid] AS EndBid,[S&H] AS Shipping FROM<BR><BR>
I just noticed that.... I was having the darnded time getting 'End Bid' to convert to currency....<BR><BR>Thanks