Search results

How do I get the datasheet view of this form to display these records grouped by Owner (OwnerID)? If I add a Group by function to the underlying parcel query I am forced to add an aggregate function to all the other fields I want included. How do you get around that?

Simon_MT, I tried your suggestion, but the list only shows one record at a time...yes I am new to using forms like this so I am probably missing something simple and obvious. I am looking for something that looks more like a table or query output list showing the whole resulting dataset after...

I am trying to structure a select query in Access 2010 that would allow me to create a form/list of owners and parcels that can be filtered on multiple fields. Tables: OWNERS OwnerID (key) OwnerName OwnerAddress Category (lookup with 7 options) PARCELS TLID (key) County Acres PropClass...

Thanks Pat! You Rock! That worked perfectly. Tom

I have a large table of property parcels and need to create from it a separate owners table. For the new table I need an OwnerID for each unique Owner. I would prefer to use a simple incrementing number for each unique owner value. Many owners own multiple parcels. So if I create an OwnerID...

I'm new to the forum, but have found several helpful solutions and insights over the years. I've been using Access off and on for about 10 years. Thanks, Tom