You'll need to do a second query for each "Root". I'd do it this way: SELECT MAX(Updated) FROM WHERE Root = 'A' --- Anthony Baratta President Keyboard Jockeys