Hey,
I have 2 tables one is called AgentFees and the other is called Agent. In my report I am displaying AgentFees records according to a date that I pass as a parameter. I need only 1 field out of my Agent table which is the agent name I get that by linking the AgentFees' Agent_Number field with the Agent's Agent_Number field. The problem is the AgentFees' table has some ficticious Agent_Numbers that won't match in the Agent table, when linked it reduces the number of records shown on the report. Does anyone know how I can still show the records that don't have a match in the field or a different way I can retrieve the agent name without linking the database fields?

Thanks for any input.