was understanding that IDRa is where you keep the daily time records for
each employee for each day. If you want to find gaps in that table, you
cannot rely on a link to another table via this one to look up a match for
the employee. For example, suppose I am EID 1111. I started on August 24.
You ask the report to run and tell you gaps on August 25. I have no time
record for August 24. Therefore, IDRa will not have a record to link to my
record in IDRb. Therefore, your report would show that I have no missing
Not knowing the purpose or structure of IDRb, I cannot say for certain if it
needs an EID field. However, if you want to use data in IDRb that is unique
for an EID, then the answer probably is Yes.
<MS ACCESS MVP>
"Randy" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...