Recent content by Marty444

Thanks for trying.:rolleyes:

Manipulating the field...Very good question! The resulting value is correct. 2*50=100 as expected and desired. But, 50 still should be recognized as greater than 6, right?

Nope, I get this kind of sorting mishap in both Access and in exported Excel spreadsheets. The data type is "number." This was not enetered as text and the database was designed from the start to read this field as a number. The same issue persists.

Numerical values in my database and exported tables are not registering as wanted. The first digit is recognized, but adding a second digit does not give the data a significantly higher value. For example a column sorted by increasing value may look like this: 2 23 24 26 3 3 3 3 31 39 4 40 42...

Tiro, That fixed my problem. What a simple solution. Thanks!

Hi there Folks, I have developed an Access database, but none of my coworkers are willing to use it. Whenever I share data with them, I have to export a table to Excel. But, when I export a certain table, the data in one column changes. Specifically, all values in one column are increased...