Dsum and dates

[FoxGolfer]

I'm trying to sum invoices for a specific date range. I've started with:
= Dsum("Paid_date","Invoices", .....) and many variations for the criteria, all with no success. What I want is every thing between 1/1/2005 and 12/31/2005. I tried "Having [Paid_date] between #1/1/2005# and #12/31/2005#" as the criteria; and variations with "'s and &'s with no luck. I guess I just don't get the way to enter the criteria correctly. Any help?
Thanks,
Tom

 

[snyperx3]

How about?

[Paid_date] >= 1/1/2005 And [Paid_date] <= 12/31/2005



-Pete

 

[FoxGolfer]

Nope, didn't do it. I got the total of EVERYTHING, not just for 2005.
Here's what I tried:
=DSum("Paid_amt","Invoices",[Paid_date]>=1/1/2005 And [Paid_date]<=12/31/2005)

 

[RoyVidar]

For litterals, you need #

[tt]=DSum("Paid_amt","Invoices",[Paid_date]>=#1/1/2005# And [Paid_date]<=#12/31/2005#")[/tt]

For a year, I suppose you could also do something like

[tt]=DSum("Paid_amt","Invoices","year([Paid_date])=2005")[/tt]

Roy-Vidar

 

[snyperx3]

=DSum("Paid_amt","Invoices","[Paid_date]>=#1/1/2005# And [Paid_date]<=#12/31/2005#")



-Pete

 

[snyperx3]

sorry roy. didnt refresh



-Pete

 

[FoxGolfer]

Thanks guys, they BOTH worked fine. It's me, can't figure out how to place literals in code.