Leading 0 won't count as duplicate

[Ardy]

Hello All.
I am using MS Access 2007. my problem is that I have table with over
177,000 records and for some reason in data transfers one of my fields
measurement_time has dropped a leading zerro. i.e 08:40 now is 8:41.
the problem comes starts with that I have exact duplicate of records
that have the same problem but I can't filterthem out becuse the
database dosn't see them as duplicate i.e 08:40 is diffrent as 8:40.
unfortunatly this attribute is a type text. don't ask me why, I just
inherited this. can anybody help me as to changing all the 4
characters records into 5 in this field by adding a leading 0. once
that happens I can use built in function to eliminate duplicates.....

Ardy

 

[KARL DEWEY]

Try this ---
Right("0" & [YourField],5)

 

[Ardy]

 Try this ---
    Right("0" & [YourField],5)
--
KARL DEWEY
Build a little - Test a little

Hello All.
I am using MS Access 2007.  my problem is that I have table with over
177,000 records and for some reason in data transfers one of my fields
measurement_time has dropped a leading zerro.  i.e 08:40 now is 8:41.
the problem comes starts with that I have exact duplicate of records
that have the same problem but I can't filterthem out becuse the
database dosn't see them as duplicate i.e 08:40 is diffrent as 8:40.
unfortunatly this attribute is a type text.  don't ask me why,  I just
inherited this.  can anybody help me as to changing all the 4
characters records into 5 in this field by adding a leading 0.  once
that happens I can use built in function to eliminate duplicates.....

Ardy- Hide quoted text -

- Show quoted text -

Thanks Works like a charm.......

Ardy