BeginDateEndDateQuery.mdb |
Post Reply |
Author | |
Roger Carlson
Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 261 |
Post Options
Thanks(0)
Posted: 20 Jan 2011 at 2:26pm |
Please consider donating $1 per sample downloaded, find out why here.
BeginDateEndDateQuery.mdb
This sample illustrates how to create a query which displays the BeginDate and EndDate of a range based on a single EffectiveDate stored in the table.
It is assumed that the Effective Date range of a record spans the time from the Effective date of the current record and the Effective Date of the NEXT record (minus 1). There are three methods shown here: Using a 1) correlated subquery, 2) DMax domain aggregate function, and 3) LEFT OUTER JOIN. Access 2000+ Download: BeginDateEndDateQuery.zip |
|
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |