Output every null-field for each table-column ...

[cuok]

HI FRIENDS!
Can somebody help\guide me to find the way
how to write a query which
outputs every null-field for each table-column for each table-row for selected date[\b]

OR

Is there a function for fields that equivalent to "for each control.."
THAMKS IN ADVANCE
CUOK

 

[Quehay]

Two questions here, one is query the other is a VBA.

Not sure what the first question is exactly but [tt] select from your_table where your_field is null [/tt] is the most likely answer.

For VBA: Sure use the record.fields() collection for a current record of a recordset.

[tt]
For Each Fld in Rst.Fields
'do something
Next[/tt]

Turn your headache into my project!
Jeffrey R. Roberts
Insight Data Consulting
Access and SQL Server Development

http://www.InsightDataConsulting.com

 

[cuok]

thank you for the quick reply, quehey. i'll try it tommorow morning (it is now 00:30 here...) and let you know how it went.
thx again,
CUOK.