Hello All,

I have a datalogger that 'sends me' the readings in a .CSV file, and this is how I convert it to a FoxPro table/cursor with the intention of using FoxCharts to display the results.

CREATE CURSOR CPdata ( ;
	RType C(24), ;
	Dtyme C(20), ;
	MilliSec N(12,4), ;
	ExcelTyme N(16,8), ;
	DCreading N(16,7), ;
	DCunit C(2), ;
	ACreading N(16,7), ;
	ACunit C(2), ;
	TempRead N(6,1), ;
	TempUnit C(2), ;
	BattPot N(4,1), ;
	GPSLat N(12,8), ;
	GPSLon N(12,8), ;
	GPSSat N(4), ;
	CPNote C(48) )
SELECT CPdata
cCPdataFyle = [C:\TEMP\UDL1_DATA\TESTDATA.CSV]
APPEND FROM (cCPdataFyle)  TYPE CSV
BROWSE  TITLE cCPdataFyle

This part of the code works just as I expect it should.
The challenge is the quantity of data that is being saved and therefore must be displayed on the chart - 1 reading per second. 3600 readings per hour, 86400 per day. I'm trying to distill the data by averaging 10 readings into 1 number for display purposes using a SQL select:

SELECT LEFT(Dtyme,18) AS Dtyme, AVG(DCreading) AS DCreading, ;
	SPACE(10) AS cDate, SPACE(8) AS cHourMin ;
FROM CPdata  WHERE RType=[DC] ;
	GROUP BY Dtyme, cDate, cHourMin  ORDER BY dTyme ;
	INTO CURSOR CPchart  READWRITE
BROWSE  TITLE [Data to Chart]

Problem: No grouping occurs (see attached screenshot).

I'm missing something..... your assistance is appreciated.