specific

  • Thread starter Thread starter fajita
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query prompt one column for multiple random values 1
Expression for Criteria for Form with Combo Boxes 1
Using "Count" in Queries 1
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Excel shortcut options 0
Combo Box, Query and Report 5
Help with "Like" Criteria 2
NEED HELP with a multi-criteria query 2

Back
Top