Error 3079

[John_G]

Hi -



Are you sure the error you get when you run the report is actually resulting from the query? Do you have that field - ta_people.DOB - on the report? If so, maybe the error is there - Access cannot determine which ta_people.DOB you are referring to.

One other thing I notice - looking at the queries, I do not see anything that ensures the the two ta_people.DOB values will be the same - are they supposed to be for the same person? What you might want to do is remove any fields from qu_IssueInfo that you do not need (or use another query), to avoid the duplication of fields issue.

John

[johnbu]

In the report, ta_People.DOB is supposed to give the DOB for the ta_People.Subject. In the query qu_IssueInfo, ta_People.DOB would lead to the DOB for Subject's children. That is what I get in the Families query. But not in the report.

What I have done is to create a new query with ta_People and ta_Spouse (qu_Subject-Spouse), then combined that query with qu_IssueInfo to create the query that the report is based on. Now ta_People.DOB appears nowhere in that query but its data appears as qu_Subject-Spouse.DOB (parents dob) and qu_IssueInfo.DOB (children's dob). The report runs fine like that.

Thanks,
John