Hi all, here I am with a new challange 
I've got a report, called Fleetlist. On this report, a list of trucks is given, based upon a selection on a form. At the bottom of the report, there is a textbox which shows how much trucks are on the fleetlist. This all works fine.
The trucks have several enviroment-criteria, called the Euro-norm. This norm is also shown on the fleetlist.
What I'm trying to reach, is that I select for example all Scania's in the fleet, and that at the bottom of the report, a texbox shows how much of the Scania's are Euro 1, Euro 2, Euro 3 etc.
So, at the end, I want to get a summary like this:
Total number of records: 30
Euro 1: 0
Euro 2: 0
Euro 3: 7
Euro 4: 12
Euro 5: 11
How can I reach this?
I've got a report, called Fleetlist. On this report, a list of trucks is given, based upon a selection on a form. At the bottom of the report, there is a textbox which shows how much trucks are on the fleetlist. This all works fine.
The trucks have several enviroment-criteria, called the Euro-norm. This norm is also shown on the fleetlist.
What I'm trying to reach, is that I select for example all Scania's in the fleet, and that at the bottom of the report, a texbox shows how much of the Scania's are Euro 1, Euro 2, Euro 3 etc.
So, at the end, I want to get a summary like this:
Total number of records: 30
Euro 1: 0
Euro 2: 0
Euro 3: 7
Euro 4: 12
Euro 5: 11
How can I reach this?
