soldat452002
Registered User.
- Local time
- Today, 04:03
- Joined
- Dec 4, 2012
- Messages
- 50
Hello Guys,
I have an access database that we use for billing.
The issue I am having is finding gaps in dates so we don't bill for that period.
So if I had a lapse within the Contract Eff Date 8/1/2007 and the Last End Date 12/31/2016 I would need to pull that data. Can anyone help me please. I tried everything so far. Thanks:banghead:
ID Year ContractEff EffEndDate
AA001 2007 8/1/2007 12/31/2007
AA001 2008 1/1/2008 12/31/2008
AA001 2009 1/1/2009 12/31/2009
AA001 2010 1/1/2010 12/31/2010
AA001 2011 1/1/2011 12/31/2011
AA001 2012 1/1/2012 12/31/2012
AA001 2013 1/1/2013 12/31/2013
AA001 2014 1/1/2014 12/31/2014
AA001 2015 1/1/2015 12/31/2015
AA001 2016 1/1/2016 12/31/2016
I have an access database that we use for billing.
The issue I am having is finding gaps in dates so we don't bill for that period.
So if I had a lapse within the Contract Eff Date 8/1/2007 and the Last End Date 12/31/2016 I would need to pull that data. Can anyone help me please. I tried everything so far. Thanks:banghead:
ID Year ContractEff EffEndDate
AA001 2007 8/1/2007 12/31/2007
AA001 2008 1/1/2008 12/31/2008
AA001 2009 1/1/2009 12/31/2009
AA001 2010 1/1/2010 12/31/2010
AA001 2011 1/1/2011 12/31/2011
AA001 2012 1/1/2012 12/31/2012
AA001 2013 1/1/2013 12/31/2013
AA001 2014 1/1/2014 12/31/2014
AA001 2015 1/1/2015 12/31/2015
AA001 2016 1/1/2016 12/31/2016