I need to divide $33,307.00 by the number of weekdays in a given month (ie. March = 22 days) in some kind of query and the total to appear in the report form
Is this possible?
I need to divide $33,307.00 by the number of weekdays in a given month (ie. March = 22 days) in some kind of query and the total to appear in the report form
Is this possible?
I think will need to build a custom function to calculate that and then call the function from query or textbox.
Google: VB calculate number working days in month
Review http://msdn.microsoft.com/en-us/libr...ffice.12).aspx
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.