Need A Hlep
Feb 23, 2008hi
i'm trying to create a database but i'm facing some problem in qury
my database contain two fields which are
recieved date and released date
both of them contain dates
i want my result to be like :
date
1-2-2008
2-2-2008
3-2-2008
4-2-2008
5-2-2008
6-2-2008
7-2-2008
8-2-2008
9-2-2008
10-2-2008
.
.
.
.
until the end the of the month
recieved
5 1
-
1
-
1
1
-
-
1
released
1
-
-
1
2
-
-
-
-
1
date will view the dates
recieved example will view how many time 1-2-2008 is repeating in the recieved date field
released example will view how many time 1-2-2008 is repeating in the released date field
finally i would view the total of the recieved and released
i hope that i will get a help from somebody