<div>
Wont it always be the 7th of the month? &nbsp;Unless you are including bank/public holidays.. Are you counting these?
</div>


Wont it always be the 7th of the month?  Unless you are including bank/public holidays.. Are you counting these?

<div>
Could also be the 5th or 6th, if the month starts on a Sun or Mon. &nbsp;I'm trying to work out the logic.
</div>


Could also be the 5th or 6th, if the month starts on a Sun or Mon.  I'm trying to work out the logic.

<div>
ahh. Sure is<br />
<br />
What about public holidays?
</div>


ahh. Sure is

What about public holidays?

<div>
Check out this link that contains a formula to find the nth particular weekday of any month:<br />
<br />
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbadev/html/findingnthparticularweekdayinmonth.asp" rel="ugc nofollow">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbadev/html/findingnthparticularweekdayinmonth.asp</a>
</div>


Check out this link that contains a formula to find the nth particular weekday of any month:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbadev/html/findingnthparticularweekdayinmonth.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbadev/html/findingnthparticularweekdayinmonth.asp]

<div>
<br />
&nbsp; &nbsp;Thanks,<br />
&nbsp; &nbsp;Will try it.<br />
&nbsp; &nbsp;<br />
&nbsp; &nbsp;
</div>



   Thanks,
   Will try it.
   
   

<div>
Still not sure what to do about holidays. &nbsp;Perhaps we could create a table, then have the user enter holidays at the beginning of the year. &nbsp;(Unless these are available somewhere.) &nbsp;We'd need to figure out what to do from there, though.
</div>


Still not sure what to do about holidays.  Perhaps we could create a table, then have the user enter holidays at the beginning of the year.  (Unless these are available somewhere.)  We'd need to figure out what to do from there, though.

<div>
<br />
&nbsp;That is good,<br />
&nbsp;I will worry about the holidays later. Will just test that functionality.
</div>



 That is good,
 I will worry about the holidays later. Will just test that functionality.

<div>
<div class="content wysiwyg-content">
<br />
&nbsp;Hello experts,<br />
&nbsp;<br />
&nbsp;In MS Access I need a VBA code to check if today is the 5th business day of the month.<br />
&nbsp;<br />
&nbsp;Thanks.
</div>
</div>



 Hello experts,
 
 In MS Access I need a VBA code to check if today is the 5th business day of the month.
 
 Thanks.

Find the 5th business day

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.