Previous month end business day in Query

  • Thread starter Thread starter dodat via AccessMonster.com
  • Start date Start date
D

dodat via AccessMonster.com

How do I set the previous month end business day so I do not have to type it
in each time I run a macro.

For example, I have 15 queries that require this field and I do not want to
prompted to type in 11/30/2006 15 times.

Thanks in Advance.
 
Use
DateSerial(Year(Date()), Month(Date()), 0)

That calculates the last day of the month prior to the current month. The
Zero-th day of a month is one less than the 1st day of a month.
 

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 last day of previous month 1
last day of month 4
Finding previous business day. 4
Previous Month Query 5
Combine Duplicates in Query 0
Calculate month ending date 1
How do I find the last business day of previous month in Access 20 4
previous day 1

Back
Top