table from table

[tony wong]

i generated a table from a query.

then i used the newly generated table to sort the result.

However, everytime i do it, i need to re-generated the table for an updated
result.

Can it make it automatically to generate the table when i sort the result.
thanks a lot.

Tony

 

[Phobos]

If I understand you correctly, you have a *Make Table* query which you are
using to sort records returned by a query.

Why not use a simple SELECT query and sort the results with an "ORDER BY"
clause?

P

 

[tony wong]

Yes, it is because i have to count number and sum of records by month.

i just know how to do it by creating a table and query again.

any other alternative? thanks a lot.

 

[Phobos]

You can base a query on another query, so instead of creating a new table
you use the SELECT query mentioned below and base subsequent queries on it.

P