I am desparate.. I have been struggling for 2 weeks on this report. I got some help regarding SHAPEing the query, but am still confused. It is such a simple report, attached. I basically have 3 tables, just link 1 common field and UNION or APPEND, as SHAPE needs for report. The key is I need to page break on RADIUS value change, which it does, I get the right records in my recordset, but the data in the details lines never changes, it repeats for the right number of lines???? I know the query is off a bit, but I am lost on this relate stuff. Please help, this is overdue already..
THanks for guidance..
My sample only has 3 fields, I figure if someone can get that to come out right, I can add the other fields..