Query in date range

  • Thread starter Thread starter wesley.allen
  • Start date Start date
W

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,
 
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.
 
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 -
Click to expand...

Thanks Karl.
 
Back
Top