The effective date is a datetime field. I need to use TTOC( , 1) with that to ensure I get the right info. I previously tried it without TTOC() as you suggest and was missing records all over the place.
Gordon de Rouyan DC&G Consulting Edmonton, Alberta Email: derouyag@shaw.ca