Creating Index or Autonumber in Query List for calculation

[Guest]

Hi,

Pls help:

I have 2 tables: 1 is Main Stock. The other is Main Historical.

After creating a query list based on a particular stock name. I could like
to carry out some calculation: IE, 10 days average prices.

As the index and trade date might not in numerical order since they are from
the main historical table. How can i create a new index or autonumber so that
i can use to reference back for my calculation.

Thank you.

Nelson Chou

 

[Allen Browne]

Simplest solution will be to create a table with the correct structure, and
an AutoNumber field. Change the query to an Append query (Append on Query
menu in query design view.) You will then have the autonumber field in this
copy of the data.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"Nelson The Missing Lead" <[email protected]>
wrote in message
news:[email protected]...