Last Full Month

[Bennie47250]

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.

 

[LittleSmudge]

No built in function Bennie

You just have to do something like :-

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



'ope-that-'elps.


G LS

 

[wemeier]

The short answer is.... NO. You're correct that you'd have to write your own functions for this.