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.

Kees