So the question goes like this:
NAME DATE PRESENTS
bob march 3 2011 1
bob june 6 2008 2
bob jan 3 2012 3
mary feb 14 1986 4
mary april 10 2001 5
mary jan 3 2012 6
kate march 3 2011 7
kate jan 3 2012 8
kate oct 9 2013 9
celia march 3 2011 10
celia feb 14 1986 11
celia july 4 2011 12
celia jan 3 2012 13
celia feb 14 1991 14
So the goal is we add the amount of presents kate and celia got on the same days if they got any on the same days
What I need to do is kind of like this except with a much bigger data set. Prolly in the 100 000 entries.
i need the answer in SQL code???? or access 2003 query SQL
