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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate multiple rows Into one Unique Identifier 1
Autolookup Query to find Multiple Records 3
Combine multiple tables with different date ranges 2
Unique ID and Latest Date 5
Calling dates from two fields... IIf - IsNull help. 1
Return multiple records from a single entry. 2
Counting in queries 2
unique records help please 6

Back
Top