table from table

  • Thread starter Thread starter tony wong
  • Start date Start date
T

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
 
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
 
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.
 
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
 
Back
Top