I have a (pretty simple) query which opens fine at design time, but
when I try to open it at runtime I get "Capability not supported" !!!

For reference, here is the query:

select ((CloseAge + ("5/22/1999" - CloseDate)) / 7) + 1 WeekOfAge,
CloseNum
from hmcstk
where CloseDate = "5/22/1999"
order by WeekOfAge

Basically it's getting a list of closing stock sorted by the age. I
can see the result set if I attach the query to a grid and open it at
design time, however at runtime it throws that error!!!

Any ideas?