>
>I'm not sure wshat is causing the problem- I've never run into it because I have never tried to create a view with a GROUP BY clause. If your view does not need to be updatable, why not just use a plain ol' SQL query?

PMFJI-

I can think of two reasons:

1. Wants the query to run on the back end(performance).
2. Doesn't want to have to grab the entire data set, only the grouped dataset(network traffic).

Ricardo - Are you sure that the view is being used nodata? Can you test it from the command window to make sure it works as advertised there?