Hi all,
normally I do everything in excel but now I have to change to access as I have to create more often Reports.
My Situation:
I have a excel list of all downloads from one client, there are more than 10.000 entries in it.
for example:
FileID Size Premium Price Date
1012866 XSmall No 1 8/23/2010
1012866 Medium No 6 10/30/2010
1012866 XSmall No 2 9/18/2011
1012866 Medium Yes 135 7/27/2012
1018171 Medium Yes 155 7/31/2012
1020987 Medium No 10 11/4/2011
1020987 Medium Yes 135 2/2/2012
1020987 Medium Yes 135 7/17/2012
1034127 Medium Yes 145 5/8/2011
1034127 Medium Yes 153 3/19/2012
1034127 Medium Yes 155 7/1/2012
I need the query to show me only files which have been downloaded(in the past month) but twice or more (in total) , and all historical downloads of the same file as well.
It's Access 2007 if you need any information let me know!
Thanks,
Rene