F fajita Jun 25, 2004 #1 I would like to set up a query by entering specific event,and by specific month that how would i write this under criteria?
I would like to set up a query by entering specific event,and by specific month that how would i write this under criteria?
M Michel Walsh Jun 28, 2004 #2 Hi, About "event", I can't tell with precision, but probably supplying a list of events you look for, in an IN list, like: WHERE TheEvent IN('eventA', 'eventB', 'eventC') For the month, use Month( ): WHERE Month(mydateTimeField) = 8 for the eight month (August). Hoping it may help, Vanderghast, Access MVP
Hi, About "event", I can't tell with precision, but probably supplying a list of events you look for, in an IN list, like: WHERE TheEvent IN('eventA', 'eventB', 'eventC') For the month, use Month( ): WHERE Month(mydateTimeField) = 8 for the eight month (August). Hoping it may help, Vanderghast, Access MVP
