Finding Duplicate Entries

[theconfusedbear]

I am running a query to find out duplicate in two fields in one table. Postcode and Address Line 1. Can anyone tell me the formula for only picking up the first 6 charaters in the Address Line 1 field??? I cant remember how to do it!

HELP!

 

[Rickster57]

characters

Did you try left([postcode],6) ?

 

[theconfusedbear]

Yeah tried that it only shows the postcodes with 6 characters ie n1 1AB - so copied the table and set the character field to 6 - thats worked!