Hi,
I "think" Duanes' link will help after you make the crosstab query and
that can be done with the wizard as your first step to help you.
The V# and VName will be a Row Heading the Date will be the Column heading
and the wizard will actuall ask you to do it by Month (if the field is a date
field) and the Check amount will be summed. After creating you can look at
both the Design and the SQL

SQL looks something like this

TRANSFORM Sum(tblPayments.Payment) AS SumOfPayment
SELECT tblPayments.CompanyID, tblPayments.Company, Sum(tblPayments.Payment)
AS [Total Of Payment]
FROM tblPayments
GROUP BY tblPayments.CompanyID, tblPayments.Company
PIVOT Format([PaymentDate],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug"," Sep","Oct","Nov","Dec");

Have only done a little with crosstabs so don't know how to apply the
"dynamic" aspect to this - but you may not need it for your situation anyways.

Craig

"DRoads" wrote:

Need help and don't know where to start. Working in Access 2007 and need to
create the following.......

Need to create the following report

V# Vendor Name Jan Feb Mar Apr
0018 ABC Co. $1,200 $ 600 $ 300 $500
0020 DEF Co. 1,800 303 212 50

Data comes in monthly from AP file (imported from SQL Server) as

Date Check Amount V# Vendor Name
01/01/09 $ 600 0018 ABC Co.
01/12/09 800 0020 DEF Co.
01/15/09 600 0018 ABC Co.
01/18/09 1,100 0020 DEF Co.

etc.

How do I go about taking multiple lines of data and create a report that
will list one vendor with multiple totals (monthly)

All help is appreciated.