database within a database
I have a large database that is updated seasonally (spring, summer, fall, winter) I would like to isolate these seasons in my database about 95% of the time, but there are times when i want to compile data from the entire database.
How would i set up a view (or button?) that would only let me work with a specific seasonal data set without having to do a search each time for that season? There is a field in each record that designates what season the record pertains to.