Creating a table of summaries by month...?

[walstib77]

I'm new to this, and I've got a table with about 180k records, and
about 12 fields per record.

These are dated transactions from October 07 to present. I have a
query that formats a new date field for each record, with just year
and month.

What I am trying to do is categorize the records by month/year, and
then provide smmaries of other felds for each subset (say, count for a
given response.)

How do I best build another table with month/year on one axis, and
stats for some of the fields on the other, and show breakdowns for
each month?

 

[Jeff Boyce]

Consider NOT building another table. That's what queries are for (take a
look at "cross-tab" queries in HELP).

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.