This is a query the wizard made
I want to add "Where Field2" = 4Code:SELECT First(Query23.[Path]) AS [Path Field], Count(Query23.[Path]) AS NumberOfDups FROM Query23 GROUP BY Query23.[Path] HAVING (((Count(Query23.[Path]))>1))
But whatever changes I attempt result in an error. How might I resolve that ?
Also why is "First" there? Is it some kind of Access command ?