Query to summarize costs by month on one line

[Guest]

I have a query which gives me FileNo, Payment Type, Payment Date (a specific
date), Amount. I would like to do a query which would summarize all payments
made to a FileNo/Payment Type and categorizes them by month all on the same
line. For example:

File PaymentType Jan Feb March -----

1 Rent 100 300 250
1 Utilities 50 20 30
4 Rent 10 30 40

Is this possible? Any help would be appreciated. I can go a query which will
give me just one month (for example Jan), but I am not sure how to combine
them all on one line.

Thanks!

 

[Duane Hookom]

This is a basic crosstab query where FileNo, PaymentType are the Row
Headings, Format([Payment Date],"mmm") is the Column Heading, and Sum of
Amount is the Value.