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
 

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

Format DatePart 4
Filtering by Month 1
Using MonthName function in 97 3
Frustrating Error: "Data type mismatch" with Subquery 3
DatePart problem with query 3
Return all dates for 'next month' irrespective of year or day 4
Using BETWEEN AND with DatePart 1
query will not work between years 7

Top