Counter

[oliviasdad]

I have a table that is updated on a monthly basis based on unique records. I need to be able to identify if a unique record appears in the following month and keep track of how many times it appears month over month (maybe adding a "1" if it appears in the subsequent month). However, if for whatever reason, it does not appear the following month, the clock should be reset to zero. Any ideas?

 

[dhookom]

clock", "unique",... You really need to provide some sample data and what you want to do with it.

Duane
Hook'D on Access
MS Access MVP