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

  • Thread starter Thread starter Tom K via AccessMonster.com
  • Start date 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
 
It works now. Sorry,
Now it returns the current month.
 
You must log in or register to reply here.

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
Frustrating Error: "Data type mismatch" with Subquery 3
Using MonthName function in 97 3
Return all dates for 'next month' irrespective of year or day 4
DatePart problem with query 3
DSUM Syntax Error 1
Using BETWEEN AND with DatePart 1

Back
Top