Hi,
I'm not sure exactly how to articulate what I want to do here, so forgive me if I'm using the wrong terminology. I am a novice when it comes to Access.
Basically I want to be able to fill out a data table using a form.
The first 4 fields are simple and would be included for every line of data. Then there are about 140 fields, most of which will be zero values. Basically, for each line of data, anywhere from 1 to 20 of the 140 fields would have a number to input, but it won't always be the same fields.
Is there a way to set up a form that has 20 inputs, where I can select which field I am inputting, then input a number. Like a drop down or something, but for the field instead of the value. So say the first line of data, I need to put a number in fields X, Y, and Z. Then, the next line, I need to put numbers in fields A, M, L, X, and Z. And so on...
Any ideas on how I might be able to accomplish this?
Thanks!