summing time data in many date selectable records.

[gazandwiz]

Hi all,
I have a large Access 2003 db that I use for logging my flying airtime.
The main table has a date field and an airtime field both are Date/Time data types.
My log book has flights from 1994 to the present time.


I'd like to be able to add all the hours up for each year, so that I can quickly compare the yearly totals.

At the moment I have a query for hours 2015 that takes the Date field from table FLIGHTLOG, tick box for show is ticked and the criteria is Between #01/01/2015# And #31/12/2015# then from the Duration field from Table FLIGHTLOG I have the Show box ticked. This fills a table with all the dates I flew and the duration. I then have another query that sums the hours from the previous query. Sum([Duration]*24), Total: expression and ticked show box.
If I want to do this for all years back to 1994 and for future years, is there a more elegant way of doing it rather than duplicating the two queries and substituting the year?

Many thanks in anticipation.
Gary

[ranman256]

turn on grouping/counting

select year([date]), sum([hrs]) as Hours from table

[gazandwiz]

Thanks, I'll give it a go and report back.
Cheers
Gary