GingGangGoo
Registered User.
- Local time
- Yesterday, 23:30
- Joined
- Dec 14, 2010
- Messages
- 121
I have successfully filtered a query pull out records with dates in the current quarter, but I would like to set up a parameter to enter the quarter #, and filter for that.
Two pertinent fields are:
DatePart("q",[SupportHrs].[DateAdded]) with criteria: DatePart("q",Now())
Year([SupportHrs].[DateAdded]) with criteria: Year(Now())
How do I set the datepart criteria as a parameter?
Thanks
Two pertinent fields are:
DatePart("q",[SupportHrs].[DateAdded]) with criteria: DatePart("q",Now())
Year([SupportHrs].[DateAdded]) with criteria: Year(Now())
How do I set the datepart criteria as a parameter?
Thanks