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

[astokes1024]

Hoping to find some answers on a strange issue. Below is a snapshot of my make table in the datasheet view. Note the data in the R12 PU% column header.




below is the data produced when I run the new table. There are several hundred records in this table, most of them are 0, but there are also a handful of 1's as well. Why is the data not transferring like my other 3 columns?






below is my sql for the make table qry:

 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_MetricsFROM RUL LEFT JOIN PTRSC_SOLByConfigAveragesR12 ON RUL.Hierarchy = PTRSC_SOLByConfigAveragesR12.CategoryClassification
GROUP BY RUL.Hierarchy, PTRSC_SOLByConfigAveragesR12.AvgUnitCount, PTRSC_SOLByConfigAveragesR12.AvgFleetSizeOEC, PTRSC_SOLByConfigAveragesR12.AvgFleetOnRentOEC, PTRSC_SOLByConfigAveragesR12.AvgOnRentPercent;

[Micron]

You can't just paste pics in here if that's what you tried. IMO, copying from a table or spreadsheet and pasting that works and is better than posting pics anyway.

[abuislam]

Hi @astokes1024, check the following:

1. Data Types: Ensure data types match between source and destination.
2. SQL Query: Verify the GROUP BY clause aligns with your data aggregation.
3. Source Data: Look for anomalies in the R12 PU% data.
4. Testing: Run a simplified query to isolate the issue.

Hope this helps!