Method for handling data across several dates

[Grady]

Hello,



I have a database project in mind and am just starting to sketch it out. I want to track information from several hundred farms over several years. I intend to collect contact information for each farm and then environmental and production specific data (farm type, crops grown, soil info, water info, etc.). I can visualize all the tables that I will need to house the data but I cant wrap my head around how to set it up in a way that would allow me to easily track the farm over time. One idea that has popped into my head has been to add a date field to all tables so the date the data was collected could be queried. When I think about this, it seems like a lot of redundant data. Does anyone know of a slick efficient way to build this into the design of a database? Any comments would be appreciated.

[ranman256]

Yes ,put in the data field.
then you just query with
where [dateEntry] between 1/1/15 and 1/1/16

[orange]

I recommend you watch videos 1,2 and 4 in this series of free videos by Daniel Soper which starts here.
Then build a model of your ideas.
Post back with result/other concerns.

Good luck.