LegionKilo
New member
- Local time
- Today, 02:47
- Joined
- Jan 19, 2018
- Messages
- 5
Good Afternoon,
(MS-Access 2017)
I have 7 date fields that have to be filled in to keep track of the training that personnel have completed. Unfortunately the data is unbelievably incomplete, and those that are supposed to be responsible for the data just don't have it.
Within the record for any particular person some of the date fields are filled in, others are not. I want to create a query that will only produce results for people that have something entered into any date field. I want to exclude records that don't have anything entered into all 7 date fields. :banghead:
Note: I'm not really capable of writing SQL just yet, but I'm learning it
Thank-you in advance.
Abe
(MS-Access 2017)
I have 7 date fields that have to be filled in to keep track of the training that personnel have completed. Unfortunately the data is unbelievably incomplete, and those that are supposed to be responsible for the data just don't have it.
Within the record for any particular person some of the date fields are filled in, others are not. I want to create a query that will only produce results for people that have something entered into any date field. I want to exclude records that don't have anything entered into all 7 date fields. :banghead:
Note: I'm not really capable of writing SQL just yet, but I'm learning it
Thank-you in advance.
Abe