Sums and Averages

[zeidberg]

Hi,
I just started using Access. I have been reading manuals all week and cannot seem to get there. I have fishery data in a 17000 row table with columns: Date, Area, Block, # boats, pounds landed. Area is one of 6 large sections of the ocean and block is one of hundreds of small areas of the ocean. On many dates, I have for example 9 entries for the date. This is because some squid were landed in blocks 709, 710, 711, etc. from the three areas NC, SCB, and SB. What I want to be able to do is sum the landings for each area, NC SCB SB, by date. So that I would end up with three entries for 4/24/01 instead of 9. Any clues?
Thank you,
Lou

 

[directormac]

This is what queries are for. If you've been reading manuals all week, should be a breeze...

Give us a little more info on your table structure and what you want to do with these summations (i.e., do you only need to see that kind of summing when you print a report, or do you need it for calculating some other value?)

--Smells-Fishy Mac