Search results for query: *

Lothario, I apologize for not posting the entire string, here it is: SELECT Parcel.UserDefinedID, Last(Parcel.ParcelID) AS ParcelID, Parcel.TaxYear AS MaxTaxYear INTO _MaxTaxYearOut FROM Parcel WHERE (((Parcel.TaxYear)= 2004) AND ((Parcel.IsRE)=1)) GROUP BY Parcel.UserDefinedID, Parcel.TaxYear...

Hey folks, I searched through the previous threads on this subject and just have been unable to get the right combination of 'group by' and joins to get the expected results in SQL Server2K. Here is the SQL string that worked in MS Access. Can anyone offer any guidance to get this to work in...

Just bumping this up, hoping that someone will have some insight. Ron

rac2 Thanks for your input. It is the last design you note that I'm trying to emmulate. In the end, I need a single record for each parcel with a first and last name pulled from the join, and a co-owner, if it exists, written to the co-owner field. Ron

Morning folks, my first post here. I'm hoping it'll be an easy one for those more experienced than I. Table 1: Parcels Parcel ID Table 2: Ownership Parcel ID Person ID OwnerStatus ('Current Owner','Current Co-Owner') Table 3: Person Person ID First Name Last Name Parcels & Ownership have a...