Bennie47250
Programmer
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.
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.