Hi I am trying to find a simple way to keep track of two record fields that will be changing on a weekly basis:
city: house median price / house inventory
There a total of 50 cities that do not change (file stays the same)
The average price for that city and inventory data changes every two weeks. I need the files separated into 50 files for the 50 cities. And I want to use one file that contains the updated data to populate the 50 existing files. After it populates the 50 files, I want to show the difference between the latest entry and the previous entry (red for negative, green for positive change). In each of the 50 files, I want to have a line graph to display the trend. These 50 pages need to be webbased documents, viewable on Internet Explorer and Firefox.