[sukkarfarid]

Dear...
I have aquestion about the report .
I give you example .

Table:

Size Date
FCL 1 X 40' 2/6/2006
FCL 2 X 40' 5/6/2006
FCL 3 X 40' 9/6/2006
LCL / 1 PALLET 1/8/2006
LCL / 2 PALLETS 2/8/2006
LCL / 3 PALLETS 3/8/2006
LCL / 4 PALLETS 4/8/2006


My question...
How can I cout the like size (FCL) = 3 as example
and the size (LCL) = 4 as example
between Date I insert it

thanks and Regards
Farid Sukkar

[colbtech]

What software are you using?

If you are using Excel, use CountIF function.

[sukkarfarid]

My software is Microsoft Acess

[ScottGem]

Add a column in a query with the expression:

SizeGroup: Left([Size],3)

Then group on that column and count the primary key field for the record. Add a Date Column as a WHERE with the criteria

Between startdate AND Enddate

[sukkarfarid]

Dear ScottGem
I need your help please see my picture and help me..
Thanks an regards
Farid Sukkar

[ScottGem]

I told you what you need to do. Did you try following the instructions I gave you.

If you want to do this in a report, you can create the query I described, without the group by. Use the report wizard to group by the SizeGroup column and use the summary options to get your counts.