Can you make your requirements more clear? An example would be nice.
Two things that are unclear:
1.There are fields "CLUB ID 1", "CLUB ID 2" etc, but then you mention "Club ID" and call it "that field". But there seems to be no such field.
2. Records can't be null. Only fields can be null.
Why didn't you make a normalised database? That tends to make your queries shorter and more simple.
I have a table with fields for Address, Club ID 1, Club ID 2, etc..
I want to build a query that asks for user input of Club ID and if any record for that field is null, return the Address field for that record.
Is this possible and if so, how?