A
Alyson D via AccessMonster.com
Hi Everyone
I have a table with information on when utility bills are paid for different
buildings. I have four date fields:
1. Date of invoice
2. Due Date
3. Coverage start date
4. Coverage end date
I would like to identify periods that are not covered between dates and 3 and
4, and also periods that are overlapping. I would like to either highlight
the dates in question, or create a report that shows the missing or
overlapping dates
Any ides would be great as i have come to a grinding halt and have run out of
ways to try.
Thanks
I have a table with information on when utility bills are paid for different
buildings. I have four date fields:
1. Date of invoice
2. Due Date
3. Coverage start date
4. Coverage end date
I would like to identify periods that are not covered between dates and 3 and
4, and also periods that are overlapping. I would like to either highlight
the dates in question, or create a report that shows the missing or
overlapping dates
Any ides would be great as i have come to a grinding halt and have run out of
ways to try.
Thanks