--- In [email protected], Dennis Jensen <[EMAIL PROTECTED]> wrote: > > --- p_stretcher <[EMAIL PROTECTED]> wrote: > > I am using multidimensional arrays declared as > > variants and am able to pull the survey number and > > the value entered incorrectly from each survey but > > I am having trouble pulling the question number of > > each data entry error which is the table column > > name. I cannot use the index since many questions > > have an a,b,c etc... part. > > > Okay I am sure you have thought about this and I'm > kind of guessing but... I think the easiest way would > be to store the Question Number along with Value > Entered. Pulling the Column Name while doable is a > lot more work than its worth. Further adding an > additional column that is a numeric (short integer I'm > guessing would do) won't take up that much more memory > and is relatively quick to do. > > Again its a sort of guess... if you don't feel this is > viable and communicate why -- then perhaps I can help > with an alternate solution.
Thanks for your input. I wrote this 4 1/2 years and ago it produced the following results. Survey# Question# Table1 Table2 263 Address 3830 TULSA WAY 3830 Julsa way 268 Q41 Boot hurts foot hurts 287 Q22a Noisy nosey neighbors I lost my original database when my computer crashed 4 years ago. It only required 1 line of code to pull the question number which is the field name for each column. I just can't remember how to reference the field name using arrays. This method is slower but much less code and work and since it is only used 1 time every 4 years for a city wide survey speed isn't important. I could add another column but am pressed for time. I am creating several other large databases while working on this. Thanks again. > _____________________________________________________________________ _______________ > Never miss a thing. Make Yahoo your home page. > http://www.yahoo.com/r/hs >
