retrieve Column Name

[drunkenneo]

abc def ghi jkl mno reason
--------------------------------


1 2 3 4
3 7 9 8

I have table in which i want to update reason column as "def missing" on 1st record and "mno missing" on second record.

Please help, Thanks in advance.

[June7]

Open the records and edit them. If you want to automate these two edits for multiple records, that would be two UPDATE queries.

UPDATE tablename SET reason = 'def missing' WHERE def Is Null;

UPDATE tablename SET reason = 'mno missing' WHERE mno Is Null;

Now what do you want to do if a record has both def and mno missing?

[drunkenneo]

i have a excel file need to imported, which has nearly 110 Columns, after importing there are required columns which should not be empty, so i was taking them out from database in form of Excel where it needs and reason for Rejection, that so column data is missing.

reason there are total 12 columns need to be check for such instances and the records are nearly more than 200, writing update query is ok, but if in single query i could fetch the column name then it would be nice.

[June7]

Think would require VBA code.

Can more than one column be missing data in same record?

[drunkenneo]

Think would require VBA code.

Can more than one column be missing data in same record?

Yes there may be but not came across yet

[June7]

This might work:

UPDATE tablename SET reason = Switch(IsNull([abc]), "abc missing", IsNull([def]), "def missing", IsNull([ghi]), "ghi missing", IsNull([jkl]), "jkl missing", IsNull([mno]), "mno missing");

[drunkenneo]

This might work:

UPDATE tablename SET reason = Switch(IsNull([abc]), "abc missing", IsNull([def]), "def missing", IsNull([ghi]), "ghi missing", IsNull([jkl]), "jkl missing", IsNull([mno]), "mno missing");

Marv.. Learned New thing Today, thanks