need a hlep

[sarab565]

hi

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

 

[Uncle Gizmo]

I am not sure I understand your question, I think what you want is:

A list of dates for the month in ascending order,

against each date two columns:
one showing number of received items
one showing number of released items.

 

[sarab565]

what i mean is i want to view dates each month in ascending order

and also i want to get the total number of recieved and also the total number of released

 

[Uncle Gizmo]

Your answer still leaves me guessing as to what you actually want. Please could you clarify.

 

[sarab565]

what i mean is that how can i create a query to view all the date between 1-2-2008 to the end of the month

 

[sarab565]

i want to create a query which will view the dates form 1-2-2008 to 29-2-2008

how can i do it??