Microsoft access can t change the data type

Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback?

Submit feedback. Thank you for your feedback! Original text must be a recognizable date or date-time combination. For example, Jan It may not display this or other websites correctly. You should upgrade or use an alternative browser. Microsoft Access can't change the data type. AlecMA New member. Local time Today, Joined Jan 24, Messages 3. I have a problem to build Pivot table in Excel The table has 50 fields and about Excel does not allowed me do Sum or Max function with this field — it needs to have Number data type.

There isn't enough disk space or memory. Thank you very much at advance. Local time Today, Joined Jan 12, Messages 32, Why not connect to a query instead of the table and in the query you can convert the datatype.

You don't have to use a table for a Pivot table in Excel, you can use a query from Access as well. Bob, Yes, I can use the query for pivoting, but the data type still going to be a "text" Thanks, Bob.

That may work. In the next dialog, enter 2 for the number of columns and then select the field below Col1. In Col1 enter values for three rows by entering 1 , 2 , and 3. In Col2 enter values for three rows by entering red , green , and blue. Select the separator between Col1 and Col2 and slide it to the left so that only Col2 appears.

Create a new record to validate the choice field works as expected. It should appear like this if it was configured properly. If everything worked properly, the choice column in Dataverse will appear like this when adding a new record. Both Access and Dataverse include the ability to store floating point numbers.

Access uses Number:Single and Number:Double for this. These data types are often used for any number column. Dataverse has a Floating Point Number data type, but it has some limitations with how it's implemented. Dataverse only allows a maximum of five decimal places. Therefore, there is a danger of losing data when migrating floating point numbers from Access to Dataverse. Because of this possibility of data loss, Number:Single and Number:Double values can't currently be migrated to Dataverse.

Migrate Microsoft Access data to Microsoft Dataverse. Log in Register. Search titles only. Search Advanced search…. Search forums. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser.

It may not display this or other websites correctly. You should upgrade or use an alternative browser. Gates Is Antichrist Well-known Member.

Joined Aug 15, Messages 1,