View Single Post
 
Old 11-21-2023, 06:34 AM
gmaxey gmaxey is offline Windows 10 Office 2019
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,378
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

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/
Reply With Quote