Working with dates
 

I have a table tracking skus by supplier. They are tracked by dates, also.
I'm trying to work up a scorecard by months and years, meaning if I want to
find out how a certain suppler did for the month of March 2007 I can write a
formula for it and track in a chart. It probably would be a better fit for
Access but not familiar with it.