Recent content by techjules

Thanks both -- I'll give both examples above a try. DHook - sorry I wasn't understanding what you were wanting ID and table name for -- now I get it :)

The field names ARE the names shown in your better formatted example. You're right - the parcel number isn't really a primary in the sense that each record has a unique identifier. I view the parcel number as kind of being a primary because it is unique to a particular parcel of land. I need...

The records in the database are land records - Field 1 is the parcel number for each address. The database contains all of the historical data for a particular parcel number. I need to isolate only the latest sale date with corresponding sale amount. In the above case, I would want the query...

Field 1 is the primary field -- it is a unique parcel number.

Thank you for responding. I don't have any code -- this was the result of a basic query. I need the query to only return the latest sale date and sale price.

I need help with a database in Access -- here is a sample of a set of data: PARCEL_NO LastOfSALE_DATE SALE_AMT OWNER NAME 0120295MF00000030 2/20/2009 100 WESLEY M G & AMY M 0120295MF00000030 1/19/1997 60000 WESLEY M G & AMY M 0120295MF00000030 6/19/1997 332600 WESLEY M G & AMY M...

Hi - need some help. I need to run a query that would compare two fields in the same record and only display those records where the two addresses don't match. Example: Row Address1 Address2 1 123 Main St 549 Baker St 2 123 Main St 123 Main...