Count records in a report using criteria

[littleboots]

I need to be able to show total numbers of bookings of twin and single rooms in a report. The rooms have different codes in the field [PKGE], so providing a list of people is no problem (sort by PKGE to get twins first, then singles).
How do I count the number of twin rooms? If I do =count(*) in the PKGE Footer, I get the number of people e.g. 20, not the number of rooms e.g. 10.
The lead passenger can be identified using another field [PAXNUMBER], their passenger number always being 1.
can I create a count expression that will only count PAXNUMBER = 1?

 

[BooneEngr]

May be you could leverage off the following query,

SELECT PKGE, Count(PKGE) AS CntPKGE FROM <<TABLE>>
GROUP BY PKGE;

If you only new the listing of those corresponding to &quot;twins&quot;, then add a WHERE clause just prior to the GROUP BY clause.