order by using a table

rbuser

Hello tech support,

I'm making a master-detail report. The master source is a query and the
detail is a table. Anyway, I'm selecting certain records with the query and
then I also use a filter on the table to further tune the records I need.
I'm building a fairly lengthy filter and it seems to run a little slower
when calculating a sum using a variable, verses keeping the filter more
simple (not that many records returned with more lengthy filter). Anyway, is
there a way to have the records I'm getting with the filter to be "ordered
by" what I want.

What's the advantage of using tables, verses queries? If the selection
criteria is more compilcated, is it better to use query components for
master-detail reports.

Thank you,

Randy

rbuser

As a general rule is better to always use TQuerys or ADOQueries, or DBExpress
Queries than tables against SQL Databases.
The TTable and it's friends (ADOTable, etc) where created for Paradox and dBase.
You should use Queries on all the other circumstances.