UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Count Sundays In Month, Access 2010    
 
   
Pastor Del
post Nov 29 2019, 10:47 PM
Post#1



Posts: 338
Joined: 27-July 10



I'm looking for an easy way to determine how many Sundays are in a given month identified by a date using VBA module. I appreciate your help
Go to the top of the page
 
June7
post Nov 30 2019, 12:22 AM
Post#2



Posts: 1,009
Joined: 25-January 16



Bing: access vba how many specified days in month

Here is one: https://www.brainbell.com/tutorials/ms-offi...n_Any_Month.htm

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
GroverParkGeorge
post Nov 30 2019, 10:33 AM
Post#3


UA Admin
Posts: 36,175
Joined: 20-June 02
From: Newcastle, WA


You can adapt one of the functions in this sample Access Relational Database Application on my website to figure out things like this. It uses several date related functions, one of which could be adpated to your needs.

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
MadPiet
post Nov 30 2019, 11:06 AM
Post#4



Posts: 3,364
Joined: 27-February 09



Or use a Calendar table (like you'd find in a data warehouse database design)
Go to the top of the page
 
Pastor Del
post Nov 30 2019, 11:23 AM
Post#5



Posts: 338
Joined: 27-July 10



Thanks, this works great.
Go to the top of the page
 
Pastor Del
post Nov 30 2019, 11:24 AM
Post#6



Posts: 338
Joined: 27-July 10



Thanks, there is a lot of good code to consider for my future.
Go to the top of the page
 
RexAbandon
post Nov 30 2019, 02:58 PM
Post#7



Posts: 60
Joined: 18-May 05
From: Chatham, Ontario


Attached File  WeekDayCount.zip ( 287.35K )Number of downloads: 5


Try this.

--------------------
Rex
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    8th December 2019 - 09:35 PM