View Single Post
  #3  
Old October 19th, 2009, 09:34 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Monthly Vendor Report

Hello,

If you need help and truly don't know where to start, I would like to offer
to help you fro a small fee. I provide help with Access, Excel and Word
applications for a reasonable fee. Contact me if you are interested.

Steve



"DRoads" wrote in message
...
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.