View Single Post
  #7  
Old October 20th, 2009, 03:55 AM posted to microsoft.public.access.tablesdbdesign
DRoads
external usenet poster
 
Posts: 13
Default Monthly Vendor Report

Steve,

I'm assuming that since you know that this forum is for FREE advice and FREE
help and that you have been told this, and reminded of this everytime you
post an offer to completely write a database for someone then I am also
assuming that your "small and reasonable fee" would be a simple a thank you
(which would be free). See where I'm going with this? So.... I would like
to take you up on your offer to supply me with a FREE database. Is that what
you're offering on this FREE advice site? How kind of you. Please post
where you would like me to send you the information for this FREE database
and I'll work with you on it. Thank you, thank you, thank you. The offer is
extremely kind of you.

"Steve" wrote:

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.



.