Search results

Thank you arnelgp, that worked. To everyone else, thank you for your time - I got a bang out of it. Jackdaw

k = rdsR!(b) is what I attempted. It fails item not found in this collection It's in a loop which creates a new "b" each pass. b is r01 on pass 1. r02 on pass 2 .. r24 on pass 24 So, what is the syntax which will take an integer from the defined cell in my table and and put it into variable k...

oops it should have have been k = rdsR! - tried several different dot and parentheses and quotes, and copied at the wrong moment. My table has 30 times 24 data points. One column gets updated every 2 weeks. I don't see how normalization would apply.

ekoto asked this January 1, 2000 but the answers did not seem to fit. Here is my code: i = 1 rdsR.MoveFirst While Not rdsR.EOF a = "" For j = 1 To 24 b = "r" & Right(Str(100 + i), 2) 'b is r01, r02, r03 up to r24 k = rdsR! ' this fails - Item not found in this...

First database program was Condor, then the dBases and Access from V1 - despite all that I am just a hobby programmer. Ottawa, Canada. In the "old" to "ancient" range. Wrote my first code (Fortran) in 1965 - didn't run. First home computer - Ohio Scientific Superboard (8k, 8 bit, Basic in ROM...