I am not sure what question your reply is supposed to be trying to answer.


I could have one or a thousand records with percentages or currency values. All will not be 0.05. What am I supposed to select how would selecting one item resolve all 1 or 1000?


I think the answer to the question asked is that column formatting applied by Excel or Access determines what is displayed in the columns but does not alter the underlying value. ADODB get the underlying value so there is no way to get the displayed value unless the displayed value is the underlying value. We have done that using the queries.



Thank you just the same.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/