If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

It may be counting the owners column, but it also should have excluded the two properties for which the owner did not change.

So, the query is doing exactly what you wanted it to do, showing you only the properties where the owner did not change. It may have also given you additional information as to the number of owners, but just ignore that additional information (if it is of no interest to you).

You can now use this as the basis of returning the detailed records associated with those properties.

Concerning the monthly functionality that you mentioned, you are going to have to supply more info on what is happening. Is there a report date field? Is there a month field? What does the data look like? Etc., Etc., Etc.

Yes. It did exclude the properties that did not change ownership. How can i get it to display the owner #?

I do have a month and year column. Eventually, I would like to query the items changing ownership and display the first time the new owner reported it.

Originally Posted by PracticalProgram

It may be counting the owners column, but it also should have excluded the two properties for which the owner did not change.

So, the query is doing exactly what you wanted it to do, showing you only the properties where the owner did not change. It may have also given you additional information as to the number of owners, but just ignore that additional information (if it is of no interest to you).

You can now use this as the basis of returning the detailed records associated with those properties.

Concerning the monthly functionality that you mentioned, you are going to have to supply more info on what is happening. Is there a report date field? Is there a month field? What does the data look like? Etc., Etc., Etc.