Rank query in macro

[Judge]

I finally figured out to get my rank query to work but it doesn't seem to use updated numbers when I run it in a macro. I originally followed the instructions off a MS article referenced on this message board to get the query to work and I'm assuming my problem lies in the fact that I have changed the table name in the query. The articles instructions say:

If the property sheet is not displayed, click Properties button on the toolbar.
Click the title bar of the Employees field list, and then set the field list's Alias property to Emp1.

I originally changed the name of my table to Terr1 and when I run the queries that this table is based on, the numbers do not change.

Does anyone have any idea how I can get this to work?

 

[jmersing]

It is a little hard to say based on your description , but if you have changed the name of a table you will have to go back to the query and change the table in the query also. If you open the quey in design view, you can remove the table with the incorrect name, then insert the new table name and make the same field selections.
I'm assuming that when you say a "rank" query , that you are using a Select query with an Order by clause?

The macro should run correctly after the query has been repaired.