Query doesn`t pull every record I asked for

[Nika]

I have recreated the table, combining the two old tables. One of my fields is
the "Employee Type". I have letters assigned to each employee.
When I created the query and asked for one of the types, the query didn’t
pull all the records.
I have created another query out of my old table and I have got all records
that I asked for.
Can somebody help me and give me some ideas how to fix the new table/query?
I will appreciate some help.

Thanks.

 

[John W. Vinson/MVP]

I have recreated the table, combining the two old tables. One of my fields is
the "Employee Type". I have letters assigned to each employee.
When I created the query and asked for one of the types, the query didn’t
pull all the records.
I have created another query out of my old table and I have got all records
that I asked for.
Can somebody help me and give me some ideas how to fix the new table/query?
I will appreciate some help.

Thanks.

No, not without seeing the query and the table structure. You're
there... we're not. Please post the SQL of the query and indicate what
values are missing.