Here's my scenario. I have created two tables within a report. Let's say TABLE 1 has 100 items FOR SALE. And let's say that TABLE 2 lists 10 items that are SOLD. What I'm trying to do is create a report that eliminates duplicates. In effect, I want to create a table with 90 items. I have joined the tables by item number, but evidently I'm using the wrong syntax (or tactic) to delete the dupes. Any thoughts, earthlings? Much thanks for any suggestions.