cauculate data depending on date

  • Thread starter Thread starter jazz
  • Start date Start date
J

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!!
 
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
 
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>
 
Back
Top