I am new to Access and I have to create a database that tracks the progress of incoming members for an organization. One of the things I need to keep track of is whether or not they have completed all 4 of the mandatory orientation sessions.
I have a table Tbl_Orientation that contains a date field for each orientation (Orient1 through 4).
I would like to create a query that sets a yes/no field as true if each of the 4 orientation date fields have an entry and false if any one of them is null.
Does anyone know how I would go about doing this?
I have a table Tbl_Orientation that contains a date field for each orientation (Orient1 through 4).
I would like to create a query that sets a yes/no field as true if each of the 4 orientation date fields have an entry and false if any one of them is null.
Does anyone know how I would go about doing this?