Get column name based on record

[LB79]

Hi all,

This may seem like a strange request but I wonder if anyone can help?

I have a table with 3 columns (Col1, Col2, Col3).
I have a record like: Col1=A, Col2=B, Col3=C.
I want to be able to do a sort of DLookup but searching all columns for "C" and returning the name of the coloumn "C" is actually in (Col3).

Is that possible at all?

 

[rzw0wr]

Look into the Field.Name property.

Dale

 

[MSAccessRookie]

Hi all,

This may seem like a strange request but I wonder if anyone can help?

I have a table with 3 columns (Col1, Col2, Col3).
I have a record like: Col1=A, Col2=B, Col3=C.
I want to be able to do a sort of DLookup but searching all columns for "C" and returning the name of the coloumn "C" is actually in (Col3).

Is that possible at all?

I would be interested to see the structure of this Table. If you are storing similar information in multiple columns of the same Table, then there is a possibility that the Database is not properly Normalized. If that is the case, and the Database is adjusted to resolve the Normalization issue, then the problem that you are posting about should no longer exist.

-- Rookie

 

[LB79]

Hi and thanks I will look into Field.Name property.

The table is part of a dynamic menu system Im developing and the table is normalised - it just sounds like its not.