I have set up a query using the wizard to search for duplicates in a particular field. This works a treat until I use it to search a table that has been updated using an import macro. This imported data is from a remote database transferred using HTML. This seems to import blank data into some of the fields so the duplicate query then recognises these balnk fields as duplicates. I want the imoport not to import 'blanks' or the query to ignore blank fields, but can't seem to get this to be done. Any ideas please.