Liveware Publishing Support Forum

sorry, i meant i was after one record per unit not one record per property

I am trying to create a report to calculate a rent per unit.____Rent is stored in a Property table and Unit information is stored in the Unit table.____For each Property there can be more than one Unit and what I want to be able to do is to count the number of Units (that meet specific criteria) tha...