writing criteria in access and using pivot in excel

  • Thread starter Thread starter marksuza
  • Start date Start date
M

marksuza

I have a query in access with the name of a person, transaction and dat
of trasaction, I wanted to group the days into weeks and then use
pivot in excel to organize in anyway. Is it better to group them i
access or excel? And if so, how do I do it so when next month come
the query or excel sheet is refreshed automatically.

Many thanks
 
Hi
for the first question: depens on several things:
- what is easier for you
- amount of data
- etc.
I'd group it in MS Access (but that's just a personal taste)

Second question: Refreshing: If you base your pivot table on your MS
Access datasoruce (a table or query) simply refresh the pivot table in
Excel and it should use the updated data
 
Thanks Frank, things are working fine but I am not getting one thing to
work though. In the pivot table I set websites as my 'row', I only
need some of them and not all from the database so I choose not to
'show all', however, everytime I update the pivot to get the new # of
hits per website, my # of rows expand to include new websites that were
added to the database. Is there a way not to refresh my rows and just
the columns in the pivot?
Once again thanks.

Marcos
 
Back
Top