Want to consult everybody a great god, and I need a monthly fixed car number of the vehicle refueling envelope and summary and mileage, but under the access don't know what I need to write a statement, the great god, please grant instruction, thank you ~ ~ ~ ~

Basic data:
Time to get that fuel car number mileage
The 2020-2-3 D - 001-5 to 20
The 2020-2-10 D - 001 June 10
The 2020-2-15 D - 002 July 30
The 2020-2-23 D - 002-2 50
The 2020-2-24 D - 003-8 to 10
The 2020-2-28 D - 003 6 40

To:
Time to get that fuel car number mileage
November 30 2020-2 D - 001
2020-2 D - 002 9 80
2020-2 D 14 50-003

CodePudding user response:

The function of Excel link access, using the Excel pivottables easier to implement,
Access will be date function after converted to YYYY - MM format, then group by