Hopefully this tip does something to addressing this issue. I know this is shouldnвЂ™t be a problem but, amazingly, people get caught by it all the time, and there doesnвЂ™t seem to be clear answers on the web. 0.5, 0.25 etc etc) and it will show up in its proper percent format. Once you set that on your percentage fields, you can enter data in decimal format (i.e. There are over fifty possible fields but the user might only select a few fields to query and the user will not want all the data fields exported. I only want to export the visible recordset from the subform. However, the data type is not integer, double, or even decimal вЂ“ it is usually single. It works of course, but I am using a datasheet view in my subform and I am hiding columns based on the users selection. The problem here is that you have to correctly set the field data type as well as the data type format. AMS User Requirements (CAMIR-AIR) - Detailed technical requirements for submitting data to AMS. So, I think even if I exported/imported in two or three chunks, I dont think the Customize Form PowerApp would even load anyway because of all the lookup columns. Right OK вЂ“ you go to your form design, set up your input fields, and then try to enter a number as a percentage, and notice that it keeps rounding to 100% or 0%. These documents contain the technical requirements for submitting documentation to CBP's Automated Commercial Environment (ACE) via the Automated Broker Interface (ABI). Ok, I tried to do an Excel export, but there were too many lookup fields (people picker and date fields) in the list to display all the fields in a view for the export.

What happens is this: You set up a field in a table, designate it to be formatted as percentage.

IвЂ™ve done this about one thousand times before and probably solved this problem one thousand times as well, but every time it happens it causes me to scratch my head (mostly in disbelief). I ran into a typical example early this morning, when I was trying to get Access to allow entry of percentages correctly. Occasionally, Access can act rather confusingly. A quick tip to fix what shouldnвЂ™t be a problem!

Export cutsheet field genius