var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Does anyone know how to find duplicates on a table?
I have a table with 55383 rows and I queried it with another table that has a matching column and I got back 55384 rows. I assume there is a duplicate.
access has a find duplicates wizard, I have never used it though, but I presume it works...
You have tables A (with 50000+ rows) and table B (with presumably far fewer rows). You are joining A to B on columns F2, F3, and F4:
In the SQL view of query design:
select F2, F3, F4
group by F2, F3, F4