Hi,

I wanted to generate a report counting the no of orders that was sent by Truck no 5.The truck no source comes from a combo box.

Combo Box list Delivery Date
Truck 5 01/02/2010
Truck 6 01/03/2010
Truck 5 22/02/2010
Truck 7 21/02/2010

The report should be appear as

Truck No Feb Mar
Truck 5 2 0
Truck 6 1 0
Truck 7 1 0

I would also like to know how does DCOUNT works.....

Thanks a lot.

Use Access help to look-up how to use DCOUNT. Additionally, look-up in Access help how to use DLOOKUP. The reason for that is that Access provides better examples with DLOOKUP.

Base your report on a Totals query and forget the DCount's etc