Thanks. I kind of thought there was something like that going on. If I remember correctly the Group On is in the totals row of the Access query design.
Hey all,
I have finally got a Query that finds the duplicate records( based on three different columns) and list all the earlier duplicates (based on transaction date) for deletion.
When i was developing this Query, with outside help, I tested it by using the 'Datasheet View'. It produced a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.