Changing field names (1 Viewer)

[Sergeant]

Hi All,
I have a table where the field names will naturally change over time. They are related to fiscal quarters, with boolean values in each row.
The changing field names have to be in response to what's available in my import file (XL), which is used to update the table via an append query. (I replace all the records with each update)
The field names are used in several places in the database, so as they change, I have to change the table, forms & queries.
When an old quarter drops off, I no longer need it. There will always be a finite number of these fields.
(Also posted on UA)

>>edit...(O.K. just realized there is no question mark in there.)
Does anyone have a general idea of how I might deal with the predicament above?

Thanks,
Sarge.

 

[yhgtbfk]

Thanks,
Sarge.

Jast call the field names

Label1, Label2, Label3, Label4 etc....

Then have a table which looks like this

Label, Description
Label1, something
Label2, something
Label3, something

Then on the form, do something like

checkLabel1 = dlookup("description", "labelTable", "label = 'label1'")
label1_label.Caption = checkLabel1

Each quarter, simply change the label descriptors in the label table

 

[Sergeant]

Thanks for buzzing in with that.
This sounds like a solution for dealing with the labeling of the changeable fields. (maybe I am misunderstanding your post)

I am beginning to have further thoughts on how to conquer this...
You see, almost every record will have "1" in the boolean field across the entire range of quarters. The ones that might have any zeroes will usually be like 10-20 out of 2600 records.

In other words, 1's are what is expected, zeroes are the exception.
Come to think of it, we don't even need to know which quarter has zeroes in it, but whether a record shows a shift from 1 to 0 in the array. (there will never be more than one shift in a record)
I could just boil this down to a single boolean field.
Even so, I still need a way to evaluate these fields, but their names will change on a regular basis.
Maybe I can do this in the spreadsheet?

Gotta go, brain beginning to smoke.
Thanks,
Sarge.