How to filter a report by only month and day, i.e."\#mm\/dd\#"

M

Marshall Barton

Nikki said:
How to filter a report by only month and day, i.e. "\#mm\/dd\#"
Click to expand...


If you don't care about the year, you can compare using
something like:
Format(datefield, "mmdd") = "0314"
 

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

How to add day to PWA 2016 date format? 0
Serial No in reports 1
HOW TO INSERT RECORD NO 4
Day of Week from dd/mm/yyyy 7
Using Access 2003 convert numeric month to text for reports 2
Access 2007-exporting reports in Excel 5
Converting MM/DD/YYYY into just MM/DD and Sorting 1
Report chart problem 2

Top