I have a new database file which i have created
in my Table i have a field called name where 5 names can be selected
from list
also have a another field where the date is typed.
What i need to do is create sometype of calulation in a report where
i can pull data
What i need to do is create a report that adds how many times the name
is in the field
that looks like below if no date is entered i dont want to add it into
the details.
Because Adam may make a sale but he doesnt get the cash till the next
day
so i need to only Add them when the date is filled in .
What i need rerport to do is this
Adam 24/12/2007 147
Adam 10/11/2007 6
John 24/12/2007 8
John 10/11/2007 44
Also need a total as well
Total
24/12/2007 155
10/11/2007 50