cauculate data depending on date

[jazz]

I need to query a table so that I can see how much we're
spending per vendor, per month...

VENDOR NAME AMOUNT DATE

vendor 1 $100.00 10/1/03
vendor 1 $75.00 10/3/03
vendor 2 $150.00 10/2/03
vendor 1 $90.00 11/1/03

I'm soooo stuck...any help would be awsome!!

 

[Andy]

Don't fear. The answer to your question pretty straight
forward. Create a query then on DATE field, go into the
properties and format it for month/year. You can format
the month/year in various ways but you can get something
like Nov-2003 by typing in mmm-yyyy for example. Next
make the query a summary query and group by the DATE field
and Sum on the AMOUNT field.

HTH

 

[Jeff Boyce]

Access treats the word "Date" as a reserved word. If you use that word as a
field name, both Access and you will be confused. Try changing the table's
field name to something else, like VendorDate, or PaymentDate, or ...

Good luck
Jeff Boyce
<Access MVP>