How to sum

[LOUIS]

Hello

using Access 03

I have a form bases on a table.
I have an unbound textbox and I am trying to sum the sales per
year
The table looks like this:
Date Sales
01/02/2008 1000
02/05/2008 3000
06/08/2009 4000
07/09/2009 8000
Any Ideas???/
Louis

 

[Jeff Boyce]

One approach might be to use the DSum() function, with Year([YourDateField])
= 2008.

But since you have data from more than one year, how do you propose to show
that in a single textbox?

And if the field holding the date is actually named "Date", you and Access
will be confused. Access treats the word "Date" as a reserved word, and
won't always mean the same thing you do...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[golfinray]

As the control source of the textbox put =sum([sales])