Hi- I have three queries:
Queries: Contain:
qryPrimary - primary_code, 1Reasons, EnteredDateCount as "CountP"
qrySecondary - 2ndary_code, 2Reasons, primary_ref, EnteredDateCount as "CountS"
qryTertiary - tertiary_code, 3Reasons, EnteredDateCount as "CountT", 2ndary_ref

In another query to combine data for a report, I need to see:
All the "1Reasons" and "CountP";
their corresponding Secondary "2Reasons", "CountS";
and finally the Tertiary "3Reasons", and "CountT" that correspond to the Secondary's.

Like a fool I thought it would be easy. I know it is probably a join problem, but I can't figure it out.

Any help would be appreciated. Stevie

To add to this... What I keep getting is a replication of the CountS figure in the tertiary column even if the Tertiary reason is blank.