> The parenthesis did it! Sharon:
Although you can do this kind of computation within a report, I always try to do it in a view if possible: CREATE VIEW MaxValues (ID, Value) AS + SELECT ID, MAX(Value) FROM Table GROUP BY ID That way, I only store the "knowledge" about how to compute max values in a single place. I can look them up in any report I need them in, get them in a form or in my program, or even just see them at the R> Prompt. -- Larry
