How do I uniquely identify records based on same product id?

M

Mike B.

I have a query that generates a table where a particular incident id has had
the same event occur multiple times in the same reporting period. Each event
has a different date within the period when it occurred. I need to uniquely
identify each of these event dates during the period as Event 1, Event 2,
etc. for each incident id. How is this done?
 
K

KARL DEWEY

You can add a field named Event. Create an update query with Ranking.

What purpose will this server as it will change as the period slides
forwards. This is one of those cases of storing calculated information in
the table and should not be done. Just calculate it each time it is needed.
 
Top