Can I assign Tasks unique identifiers?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

As part of my monthly report, I need to export my Task List to MS Access where various other employees can create specific forms and reports from the information.

There will be months where data may overlap and I do not want duplicates. Since some of the tasks are as often as weekly, duplicates may not be immediately apparent...

I was hoping there was a way to have a unique identifier so Access will filter out identical records.
 
Something other than a unique identifier in the subject field? Will the
created or modified date field work?
 
I am not sure, I can try that. Since the recurring appointments have different dates, that should work... Thanks for the suggestion!
 
It does not seem to work unless I can format the time into the date as well. Hours and minutes would probably work, but I would want to add seconds as well. Is there a way? I am using Office 2000 if that makes a difference...
 
Guess at the seconds? :)

I'd use the format 200801260850xx - and guess at the seconds. (Or
801260850xx for a shorter code) If you need a more automatic way to enter
this, I highly recommend ActiveWords. (http://www.activewords.com/)
 
Back
Top