Thursday Count

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Giberish - 08 May 2007 23:07 GMT

I have tried several Data functions to determine how to count the
total number of "Thursday's" in a given month. For instance:

If I choose to find out how many "Thursday's" are in the month of
September in any given year, how can I find this by not writing a
complex code in VB?

Reply to this Message

ruralguy - 09 May 2007 00:31 GMT

Maybe this link will help:
http://www.mvps.org/access/datetime/date0011.htm

>I have tried several Data functions to determine how to count the
>total number of "Thursday's" in a given month. For instance:
>
>If I choose to find out how many "Thursday's" are in the month of
>September in any given year, how can I find this by not writing a
>complex code in VB?

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message

Giberish - 09 May 2007 01:35 GMT

On May 8, 7:31 pm, "ruralguy via AccessMonster.com" <u12102@uwe>
wrote:

> Maybe this link will help:http://www.mvps.org/access/datetime/date0011.htm
>
[quoted text clipped - 10 lines]
>
> Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200705/1

Thanks RuralGuy, but I was looking for a more simplistic breakdown
within a query. Can I call a VB function within a query?

Reply to this Message

ruralguy - 09 May 2007 03:07 GMT

Both intrinsic function and UDF's are available in queries.

>On May 8, 7:31 pm, "ruralguy via AccessMonster.com" <u12102@uwe>
>wrote:
[quoted text clipped - 6 lines]
>Thanks RuralGuy, but I was looking for a more simplistic breakdown
>within a query. Can I call a VB function within a query?

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Reply to this Message