Parameter Quarter #

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
 
Replace the current criteria with something surrounded with brackets, like so:

[Enter Year]

[Enter Quarter]
 
Replace the current criteria with something surrounded with brackets, like so:

[Enter Year]

[Enter Quarter]

Ah ha! So simple! That did the trick - Thanks!!
 

Users who are viewing this thread

Back
Top Bottom