Any guesses as to why a query would not pull all the data from a table? The query is matching data from one prior query to data in another table.
TABLE 1 - LISTS ALL OUR EMPLOYEES - 5348 records:
employee list
employee's budget #
(and a bunch of other fields, not relevant to this question)
QUERY 1:
contains all our budget #s
administrator assigned to oversee each budget #
(the link is the budget #s, as you might guess)
QUERY 2 THAT I'M ASKING ABOUT:
results desired is a list showing all 5348 employees, their respective budget #, and the related administrator
(purpose is to have a handy list to respond to employee budget questions... ("Oh, I see you're in budget 12345, I'll call Susan who is your admin.")
RESULTS COME BACK AS DESIRED *BUT* WITH ONLY 4388ish RECORDS -- ??? It makes no logical sense, everything else is fine.
Any suggestions what I should check?
Thanks,
Cindi
(newcomer, first post)![]()