record counting

[Julie]

I have two tables OWNER and PARCEL

I have 340 OWNERS and 2400 PARCELS

I would like to make a report that shows how many parcels each owner has.

Any ideas?

 

[Dirk Goldgar]

I have two tables OWNER and PARCEL

I have 340 OWNERS and 2400 PARCELS

I would like to make a report that shows how many parcels each owner has.

Any ideas?

Presumably there is a field in the PARCEL table that links each parcel to
its owner. Suppose that field is OwnerID. Then you could build a simple
totals query with SQL like this:

SELECT OwnerID, Count(*) As NParcels
FROM PARCEL
GROUP BY OwnerID;

 

[John Spencer]

Is there a field in Parcel that shows who the owner is?

SELECT OwnerID, Count(ParcelID) as CountParcels
FROM Parcel
GROUP BY OwnerID

You need to build a query as the source for the report.

Open a new query
Add the Parcel table
Add the Owner field to the grid twice
Select View: Totals from the menu
Change GROUP BY to COUNT under one of the fields.
Save the query and use it as the source of the report.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Julie]

I rated you wrong, sorry, it was very helpful and I got it to work. Thank you
very much Wish I could change the rating.

 

[Troy]

You would need a primary key field in the Owner table and that same key field
in the Parcels table. Assuming an owner has many parcels.

You would then create a query.
Link the two tables via their keys in the query designer.
Add owner name field and a parcel field.
Set a group by on the owner and use the 'count' criteria for parcel
Run the query

 

[lourdesbolla]

Yes!Lourdes

 

[Howard Burgman]

Yes!Lourdes

 

[lourdesbolla]

Venho por meio desta sob o Edital 1542 me por na função de controller da
Empresa Microsoft Corporation.
Atenciosamente.
Maria de Lourdes Bolla Molins.
Grente de T.I