I have a left joined query that contains a simple calculated field Nz([CERTIFIED_US_AMT]-Nz([DEOB_AMT])) with field named "Total". The two tables are humongous (almost 5 million records each) but still only add up to 1.8GB so it within Ms Access limits. BUT, when I export it, the total column will not display as numbers. I tried to use the "convert to Numbers" feature with no success. Never had this problem before. Query is attached.