Microsoft Access - Report Query Not Working

Problem:

Using Microsoft Access 2007, I designed a report using multiple objects utilizing the same table. i.e. employee & customer both using a table called "person" to store data. Using the query designer, two versions of the person table were represented: person and person_1. After I saved the design and viewed the report, the fields were messed up.For example, both employee.name and customer.name showed the employee.name.

Solution:

Save the query external to the report, then reference in the report design.

Explanation:

Don't know. I beat my head on the wall for awhile on this one. It's just part of the quirkiness of Microsoft Access. I suspect that it had something to do with multiple references of the same table to represent different data objects in the report. For some reason, thank goodness, I discovered a simple workaround.

Lesson Learned:

If an embedded/implicit query in a report (or form perhaps) doesn't behave correctly, try saving outside of the form and referencing like a table. It might be a good habit to always save your queries this way.