Recent content by jimward

  1. J

    Combine multiple UPDATE queries

    I would like to combine 4 UPDATE queries into a single query but don't know how. The four queries are: UPDATE tblToDeeds INNER JOIN tblProperties ON tblToDeeds.ToDeedID = tblProperties.PropID SET tblToDeeds.TransfDate = [tblProperties].[OwnDate]; UPDATE tblToDeeds LEFT JOIN tblProperties ON...
  2. J

    Question How to work with a To and From table in Land Parcels

    Hi. Thanks so far for suggestions. I did not realize I had not actually asked a specific question. Firstly for the person who suggested using a geographic coded ID for a property plot, I need to point out that here at least [Canada] a property can change size at every sale transaction. It can...
  3. J

    Question How to work with a To and From table in Land Parcels

    Hi, I have a database set up for our historical society to show historical ownership of land parcel/properties in our area. I have one 2 column table showing the relationship of Title Number and what the new Title number is when the property is sold. So Property Title #1234 is now Title #4567...
See more
Top Bottom