specific

F

fajita

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

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
 
Top