Hi Guys,
I make a software for container depo and warehouse, and I want to calculate how many container come in each day in the certain month.
For example :
container code date in (mm/dd/yy)
xxxxxxxx1 12/01/01
xxxxxxxx2 12/02/01
xxxxxxxx3 12/02/01
xxxxxxxx4 12/02/01
xxxxxxxx5 12/05/01
etc
in my report/ query, I want to make a report such :
Date sum of container in
12/01/01 1
12/02/01 3
12/03/01 0
12/04/01 0
12/05/01 1
etc until the end of the month
So from the query I can make a statistical report or chart to shows how many container come in each day.
Does anyone can help me please?
thank you in advance
I make a software for container depo and warehouse, and I want to calculate how many container come in each day in the certain month.
For example :
container code date in (mm/dd/yy)
xxxxxxxx1 12/01/01
xxxxxxxx2 12/02/01
xxxxxxxx3 12/02/01
xxxxxxxx4 12/02/01
xxxxxxxx5 12/05/01
etc
in my report/ query, I want to make a report such :
Date sum of container in
12/01/01 1
12/02/01 3
12/03/01 0
12/04/01 0
12/05/01 1
etc until the end of the month
So from the query I can make a statistical report or chart to shows how many container come in each day.
Does anyone can help me please?
thank you in advance