Hi,
I'm a beginner with a project in the works and am stuck on the following, any help would be much appreciated:
I am importing a comma delimited TXT file using chunks, then splitting the chunks into seperate strings, filtering the strings to match a certain criteria and then dumping these strings into an MSFlexgrid using the addrow option.
the data is in the follwing format in the msflexgrid
bb, xx, yy, zz
what I'm trying to do is to run a query on the msflexgrid which will provide me with the average sqrt of (xx sqr + yy sqr) when the zz values are the same and then dump this value out to another msflexgrid with the zz value to which it applies ie
the average squareroot of the sum of the square of xx and yy equals "a" when zz equals "b" and so on for whatever values of zz occur within the msflexgrid.
A bit confusing I know but I don't know how else to explain it.
In addition to this I also want to display the xx, yy, zz values from the msflexgrid on an xy scatter chart.
Any help would be really appreciated as I'm stumped and my book doesn't help.
Cheers
Tee Jay
