Access chart changing text number to scientific notation

Question

I have a bar chart object on an access report. Labels display my 8 digit text number properly. When I add a data table to my classic Access charts, my labels change to scientific notation.

I have verified all fields from tables, queries, forms, reports, etc. are text. I have tried reformatting the data and fields. Nothing seems to work.

Has anyone ever come across this and how do you fix it? This data is input directly into the database and is not imported from a spreadsheet.

Table1 - Un_ID is Auto Number and Un is Short Text.

Un_ID	Un
1	12345678
2	12345679
3	12345680

Table2 - G_ID is Auto Number, G_num/Un_ID/Base/Actual are Integers, G_name is Short Text.

G_ID	G_num	G_name	Un_ID	Base	Actual
1	1	G1	1	2	5
2	2	G2	1	2	7
3	1	G1	2	2	3
4	2	G2	2	2	12

Query1

SELECT Table1.Un, Table2.G_num, Table2.G_name, Table2.Base, Table2.Actual FROM Table1 INNER JOIN Table2 ON Table1.Un_ID = Table2.Un_ID WHERE (((Table2.G_name)="G1"));

Chart Query

SELECT Query1.[Un], Sum(Query1.[Actual]) AS SumOfActual
FROM Query1 GROUP BY Query1.[Un];