I have an Access DB with a Table containing the fields
ID
Pilot
Flight Date

Each Pilot accessing the DB enters the date of his flight each time he makes
a flight.

Now I would like to be able to extract from this Table for each Pilot the
number of times the Pilot has flown in each month. How can I do this?

Mike Glazer wrote:

flds to columns. In the third column enter
YyMm : Format([Flight Date],"yyyymm")
In the 4th column enter
Cnt : ID
BTW, the column heading Cnt is separated by the field name with a colon.

From the menu bar select View/Totals.

For ID and Pilot and YyMm columns they should be GroupBy. Change
GroupBy to Count for column Cnt.