This will not work in criteria row. MonthName(DatePart("m",Date()))

  • Thread starter Tom K via AccessMonster.com
  • Start date
T

Tom K via AccessMonster.com

Im using this calculation "MonthName(DatePart("m",Date()))" in a criteria row
of a query field that returns months of the year. I want the criteria to only
return fields that are the current month. Its not working. Why doesn't this
work in the criteria row?

Thanks

Tom
 
Top