Search results

Thanks for the advice - Append Query is interesting, and so is the idea of just adding the new address and marking it as the 'current' address. Either will work for me. Thanks for your time and support. Dave

Thanks RuralGuy - I take it I will need to copy the current address into the "previous address" table before entering the new details. Would this be done by vba or can this be done by some sort of update query? Thanks again.

Hi Sorry if this is in the wrong forum. I am pretty new to access and am putting together a patient list, and was wondering if any one gan provide some pointers on how to deal with an issue of patients moving house. To ensure you have the correct patient it is sometimes useful to not only...