Creating key in datatable to not overload excel pivot table

[Guest]

I have an Access datatable with millions of futures trades. I can create an
Excel pivot table but it only allows me to view grouping of trades by
product, or account. I cannot view individual trades becuase the unique
field "ID" has to many unique values. So one idea I had is to just create a
numeric key for an account's trades for the day. So if the account has 10
trades in a day a running total is created. How can I create something to do
this? Maybe there is something simpler?

 

[John W. Vinson]

I have an Access datatable with millions of futures trades. I can create an
Excel pivot table but it only allows me to view grouping of trades by
product, or account. I cannot view individual trades becuase the unique
field "ID" has to many unique values. So one idea I had is to just create a
numeric key for an account's trades for the day. So if the account has 10
trades in a day a running total is created. How can I create something to do
this? Maybe there is something simpler?

Um?

Index the date field, and base the pivot table on a Query selecting one day's
trades.

John W. Vinson [MVP]