I can't believe it took three people to make me see this! I guess I'd just
been at it too long because when I came back in this morning and read the
comments over again, I realized immediately you were all right. I guess my
brain was just too overworked. It really needed the weekend off.

Thank you all so very much!

"Marshall Barton" wrote:

John Vinson also said the same thing so be sure to read his
reply. Maybe he explained it in a way that is more
understandable.
--
Marsh
MVP [MS Access]


Tara wrote:
I have to leave for the day soon and I won't be able to get back to this
until Monday morning. Thanks so much for all of your help and I hope I can
touch base with both of you again on Monday to pick your brains some more
about this issue.

"Tara" wrote:
That's essentially what Daryl said to look for too, but I can't find it. The
only criteria is on PostedDate which originally comes from tblContacts, the
"one" side.

"Marshall Barton" wrote:
Tara wrote:
I have a query set up with a one-to-many left join on two tables in order to
pull all records from one table (the "one" side) and the corresponding
records from another table (the "many" side), if they exist. It works well,
but only in THAT query. In other words, if I run that query, the records
show up as I want them to. But, if I then use that query in yet another
query to further manipulate the data, the only records that show up are the
records in the many table. Why and how can I fix it? I can post the query
if needed.


Your second query probably has a criteria that weeds out the
records from the many side table that were not there to
begin with. Any criteria that compares a field in the many
table to anything will do that.
.