jwcolby
jwcolby at colbyconsulting.com
Sun Feb 3 16:16:54 CST 2008
The data is already at least 5 years old! I have pointed this out and asked if we want to try to move the data into a single field. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Saturday, February 02, 2008 3:44 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] SQL Server Pivot >> This method of storing the Age is just a royal PITA. Not to mention the boundary conditions: within a year, people in the 45-54 category will move to the 55-64 group. An unenviable task. A. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com