CMTH said:
The table I am including all records from has 27 records. The table
I am joining to has only 15 records. The query is returning a total
of 135 rows. I am using a date range for my criteria, so the same
date can be seen multiple times in the matching table as well as the
all records table.
Those numbers are irrelevent. When you have a query where you display all
records from TableA and matching records from TableB then any duplicates in
TableB will cause you to get duplicates in your output. That will mean an
output with more rows than TableA has.
When I say duplicates in TableB I mean only on the field or fields you are using
in your join. Any other fields could be different.