>You can either create view programmaticaly or use alternate view editors.

*mutter* Thanks for the answer. Time to send Microsoft an ER.

[Update] Bizarre. I wrote the view in code and tested it from the command prompt. DBGetProp showed the correct SQL. A few requeries showed correct results. Running the form that calls for this view crashed out with Error 1494 again.