Query in date range

[wesley.allen]

Hello. Thanks for helping.

I would like to create a query that will sum up expenses for various
categories within a date range. I have created the query that sums
the amounts, but I want it to use a high end of "Date()" or "Today()"
and a low end date range that is the first day of the current month.

Any idea if this can be done?

Thanks,

 

[Guest]

Use This --
Between Date()-Day(Date())+1 AND Date()

Remember that Date() is as of midnight and will not return a record as of
any time after midnight so add a day like this --
Between Date()-Day(Date())+1 AND Date()+1

Day(Date()) pulls today - 31 and when subtracted from today equals the last
day of last month so I add one more for the first of this month.

 

[wesley.allen]

Use This --
Between Date()-Day(Date())+1 AND Date()

Remember that Date() is as of midnight and will not return a record as of
any time after midnight so add a day like this --
Between Date()-Day(Date())+1 AND Date()+1

Day(Date()) pulls today - 31 and when subtracted from today equals the last
day of last month so I add one more for the first of this month.
--
KARL DEWEY
Build a little - Test a little








- Show quoted text -

Thanks Karl.