Search results

  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, 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...
Back
Top Bottom