I have a main table with all columns that are needed for keeping track of patient information of supplements that are sent from different companies. Another table with company Names, another table with supplement names. My company is wanting to add dates we they will know monthly the cost of what is being spent. I have that set up in queries already done. My question is: how can I go to a previous date of patient info that supplements were sent and add a new date and still have the old info stay there. We are wanting to retain price spending. "Karen" wrote: > I have a database with alot of patient information with dates. Instead of > re-creating the same patient info and add new info for the patient, how can I > edit the old with new info and keep both.