Access 2003 query question
by kleod - 2/25/12 12:36 PM
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?