Hi,
Just after a bit of help please:
I'm trying to create a query that counts the number of duplicate records in a table, but that only looks at values outside a set of parentheses, so for example, the table field looks like this:
12345 (ABCDE)
And I want to count the number of times 12345 appears in the table, without considering what's between the brackets containing ABCDE.
I can get most of the way there, but can't work out how to specify the criteria.
Any advice would be gratefully received, thanks
Just after a bit of help please:
I'm trying to create a query that counts the number of duplicate records in a table, but that only looks at values outside a set of parentheses, so for example, the table field looks like this:
12345 (ABCDE)
And I want to count the number of times 12345 appears in the table, without considering what's between the brackets containing ABCDE.
I can get most of the way there, but can't work out how to specify the criteria.
Any advice would be gratefully received, thanks