How many Container come in to depot each day?

[budich]

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

 

[budich]

please help !!!!!!
Thank's a million

 

[jocat]

You must create a summation query.

Go to the query tab. Select "New"

The query will consist of two fields, " container code" and "date in"

When you have selected these two fields for your query, click on the summation button on the toolbox (it looks like the greek letter SIGMA)

On the total line, select "Group By" for the "Date In" field. and select "count" for the "container code" field.

On the criteria line for the "Date In' field, type

Between[enter start date]and[enter end date]

Save the query.

When you run the query it will ask you to enter the start date (enter the month, day and year in the format mm/dd/yy), and then it will ask for the end date (enter in same format).

The query should display the date in one column and the number of containers on that date in the second column.

 

[budich]

Thank's a lot Jocat,

it works, however if the certain date no container (nill amount) it won't appear in the query.

Date sum of container in
12/01/01 1
12/02/01 3
12/03/01 0 -----this line is not appear
12/04/01 0 ----- this line is not appear
12/05/01 1
etc until the end of the month

How to make those lines appear even it have nill value
thank you,
regards
Budi

 

[HoleInTheFoot]

Ensure all dates are entered when zero containers delivered
this will resolve your requirement

 

[budich]

Thanks Hole In the Foot,

Yes, but we type in the date only when there is container come in. Some times several days no transaction.
How to make query to make each day of the month?
Thank's in advance