Lookup field name

[caniread]

I have 5 fields that I need to look at in a query. The query will only have one row. Only one of the 5 fields will have a number in it. I need to write code that will look at these five fields and find the one with a number in it and return the field name in an unbound box in a form. I am not sure how to go about writing this code, can someone point me in the right direction?



Thank you for the help,

Isaac

[June7]

Will the other fields have data? Do you need to find a specific number or just if it has any number?

I suspect the data structure is not normalized. What is this data for?

[caniread]

There are more than five fields in the query but I only need to look at the five fields and only one of the fields will have a number. That is the field name I need to return on the unbound box. I already have it filtered down to a single row to look at every time it runs the code. Hopefully that makes sense.

[June7]

Not quite an answer to my questions. So any number? Will other fields have any data? The field will contain only number, no alpha?

You don't really need the field name, you need the data. Consider:

Nz([Field1], Nz([Field2], Nz([Field3], Nz([Field4], [Field5]))))

or

Choose(IsNumeric([Field1]),[Field1], IsNumeric([Field2]),[Field2], IsNumeric([Field3]),[Field3], IsNumeric([Field4]),[Field4], IsNumeric([Field5]),[Field5])


If the five fields are mutually exclusive - only 1 can have data - this is not a normalized structure.