I have a MicrosoftSQL database with a list of properties sold in an area over the past five years. I want to search for properties that have been sold multiple times over the past years, and show the change in value of the property, while being able to organize the data by time period as well as location. It would be difficult for me to organize the information into multiple databases by year-how can I do this out of one file?
Much depends on how your data is structured. Can you post a sample?