1

Topic: Duplicate records report H1/H2

I haven't tried these for years, having found them to throw up 1000s of erroneous records because of the fields it queries, but was trying to look for some duplicates in a batch of data that one of my staff had just imported and thought I'd try it again. But this time I get an error message. In both queries I get this:

'Incorrect syntax near '="

They are version 5 - 28 November 2014.

Have I missed an update for these somewhere along the line please?

Thanks
Purgle

Purgle Linham
Wiltshire & Swindon Biological Records Centre

2

Re: Duplicate records report H1/H2

I have fixed this report H1 and H2 and new versions are attached.  It isn't that difficult to build in more criteria for identifying duplicates  so if there are other fields which need including let me know.

Post's attachments

JNCC_H1_Duplicates.xml 6.95 kb, 4 downloads since 2016-05-20 

JNCC_H2_Duplicates.xml 7.49 kb, 3 downloads since 2016-05-20 

You don't have the permssions to download the attachments of this post.
Mike Weideli
Littlefield Consultancy - IT Consultants

3

Re: Duplicate records report H1/H2

Fantastic thanks Mike.

PS did you see my email about R6 support?

Purgle

Purgle Linham
Wiltshire & Swindon Biological Records Centre

4

Re: Duplicate records report H1/H2

Yes. I have replied twice to your email. Not sure why you are not receiving them. Will look again.

Mike Weideli
Littlefield Consultancy - IT Consultants