Count record in Report

[loissuha]

How can i count the record in a report like as you see in the picture ..

i need your idea and your help ...
please help me

best regards
Farid Sukkar

[PEB]

Hi Farid,

I suppose you need a query that returns the count of records grouped by your shippement and especially the first 3 letters in your shippement

So you need to introduce in Queries, Query View choose SQL view and type the following SQL:

SELECT DISTINCT MID([SizeOfShippement],1,3) AS Shippement, Count(MID([SizeOfShippement],1,3)) AS Count
FROM [YOUR TABLE]
ORDER BY MID([SizeOfShippement],1,3);

Please change [YOUR TABLE] with the name of your table source of the data

Have a nice day! :)

[loissuha]

thank you for help me ...
when i do as you told me ... the message error appear to me

please visit the websit i upload to you my Database project ...
please download and try it ..

http://rapidshare.de/files/32592426/project_.rar.html

another website ..

http://www.sendspace.com/file/xacwsq

thank you very much for help me

[PEB]

Try the follow:

SELECT Mid([Size],1,3) AS Sizes, Count(SeaTable.Size) AS CountOfSize
FROM SeaTable
GROUP BY Mid([Size],1,3);

And it seems You know something for Bulgaria, don't you???

[loissuha]

thank you ....
you are the best one ...

can i ask you >>
How just the query (FCL and LCL )

the code is successfully work ... but i ask you how just (FCL and LCL)

thank you in advance
farid Sukkar

[loissuha]

i solve it ...

add on the code ...

HAVING (((Mid([Size],1,3)) Like "fcl*" Or (Mid([Size],1,3)) Like "LCL*"));

thank you ..
Farid