I notice that access does a wonderful job in the pivot table of allowing you to analyze data with along a wide range of timeframes based on the date and time entered for each record. In excel, I had to add columns in excel and give them a respective format (i.e. year, month, week, etc). Does excel have the same capability now as access to look at a date and break it down in the pivot table automatically?

Second question...the reason I think I need to export data into excel is because I still have some v-lookups on excel that I use to calculate repair costs (by looking at the fabric type and amount used). I assume I don't have that capability in access, do I?

Thank much,