Make Table Query is creating a different data set in the created table, but only for 1 column.

[astokes1024]

I pasted pictures that didn't appear in a previous thread with the same Title. I'm a newbie and it seems like there isn't a way to edit or delete a thread so I just started a new one.

My issue:

I have a make table qry that is displaying this in the datasheet view:

Class	R12 Avg	R12 OEC	PU $	R12 PU %
1000	245	6386776	5440409	.852
2000	16	209490	121322	.579

My created table is producing the following:

Class	R12 Avg	R12 OEC	PU $	R12 PU%
1000	245	6386776	5440409	0
2000	16	209490	121322	0

why is only my R12 PU% column not returning valid records?

this is my Make table SQL:

SELECT RUL.Hierarchy, PTRSC_SOLByConfigAveragesR12.AvgUnitCount AS [R12 Average Unit Count], PTRSC_SOLByConfigAveragesR12.AvgFleetSizeOEC AS [R12 Average OEC], PTRSC_SOLByConfigAveragesR12.AvgFleetOnRentOEC AS [Physical Ute ($)], PTRSC_SOLByConfigAveragesR12.AvgOnRentPercent AS [R12 PU%] INTO qry_make_table_CC_Performance_Metrics
FROM RUL LEFT JOIN PTRSC_SOLByConfigAveragesR12 ON RUL.Hierarchy = PTRSC_SOLByConfigAveragesR12.CategoryClassificatio n
GROUP BY RUL.Hierarchy, PTRSC_SOLByConfigAveragesR12.AvgUnitCount, PTRSC_SOLByConfigAveragesR12.AvgFleetSizeOEC, PTRSC_SOLByConfigAveragesR12.AvgFleetOnRentOEC, PTRSC_SOLByConfigAveragesR12.AvgOnRentPercent;

[Micron]

I suspect your resulting field is of data type integer or long, neither of which can contain decimal portions of a number. Your results also look like text as they appear to be left justified but can't tell for sure. Try entering the value you expect directly in the table and it probably won't work. Change field property to Double, save, then try editing again.

I can't think of a reason why you cannot edit the other thread. Site is very slow lately so maybe you didn't wait long enough when you tried. We're also getting time-outs on page loads.

[Welshgasman]

You CANNOT paste pictures on this site.
You need to use the attachments button, then they look as pasted.
Always worth previewing a post anyway before posting.

[astokes1024]

That was it! Thank you