Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Last Full Month

Status
Not open for further replies.

Bennie47250

Programmer
Nov 8, 2001
515
US
Hi All,

I do a lot of reports using Crystal Reports and every once in a while I need to do a report/query using Access 2002. Well for this request I'm going to be using Access 2002 and need help selecting records.

In Crystal they have set of neat data functions that will allow you to pull off the date field by last full week, last month, by quarters and quite a few more. Does Access have this too?

For this report I need to pull records for the last full month. Does Access have a way to this?

Thanks
Bennie

PS: I sure I could write some formulas that takes the current date and make this determination but before I do this, wanted to know if this is already built in or if anyone has a better suggestion.
 
No built in function Bennie

You just have to do something like :-

DateField BETWEEN #01/" & Format(Month(Date())-1,"mmmm") & "/" & Year(Date()) & "# AND #01/" & Format(Month(Date()),"mmmm") & "/" & Year(Date()) & "# - 1 ) "



'ope-that-'elps.


G LS
 
The short answer is.... NO. You're correct that you'd have to write your own functions for this.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top