T
Tim Whitley
I have a large amount of account history (300K records) in one table. There
may be multiple start and stop records for one account. I would like to
create a query that identifies accounts that have a start between a set of
dates and a stop between a set of dates. The dates are in YYYYMMDD format.
For instance, from the example table below, I would like to find the accounts
that both have a start date between 20051001 and 20051031 and a stop date
between 20060301 and 20060331. The only account meeting this criteria is
12345.
Account Number Type Effective Date
12345 Start 20051002
67891 Stop 20060101
12345 Stop 20060315
67891 Start 20051024
22222 Start 20050810
33333 Start 20060503
44444 Start 20060415
22222 Stop 20060404
I tried creating 2 queries: one that identified qualified stops and one
that identified qualified starts but could not figure out how to get the
commonalities of the two queries. I'm sure the answer is obvious...just not
to me. Thanks in advance for any help!
may be multiple start and stop records for one account. I would like to
create a query that identifies accounts that have a start between a set of
dates and a stop between a set of dates. The dates are in YYYYMMDD format.
For instance, from the example table below, I would like to find the accounts
that both have a start date between 20051001 and 20051031 and a stop date
between 20060301 and 20060331. The only account meeting this criteria is
12345.
Account Number Type Effective Date
12345 Start 20051002
67891 Stop 20060101
12345 Stop 20060315
67891 Start 20051024
22222 Start 20050810
33333 Start 20060503
44444 Start 20060415
22222 Stop 20060404
I tried creating 2 queries: one that identified qualified stops and one
that identified qualified starts but could not figure out how to get the
commonalities of the two queries. I'm sure the answer is obvious...just not
to me. Thanks in advance for any help!