I'll take a peek at the articles but, to answer your question. I need to count the number of visits by the weeks in the month. If the month starts...

Also, the count of visits begins on the first day of the month and ends on the last day. If this is too complicated for this forum, I understand.

Thanx but, I need the week ending on Saturday, not WeekCommencing on Sunday, or if the last day of the month is after the last Saturday then, that day would...

Thanx.

I'll take the advice of you folks and go with the calendar.

Thanx.

I'll supply the year through a variable but, let's start with 2013.

There's got to be something elegant out there.

Oops. Sorry.

Use getdate() instead of ApptDt. So, what is Saturday's date, given the week number?

Thanx.

My bad. The sample data was a bit too simple. The data I gave only had one patient per day. Docs have multiple visits per day but, I still only...

Sorry about the date format and thanx for the help. I'll be better prepared for my next post.

I need the result to be.........

FAMILY PRACTICE BARNERT M.D.,RUTH OCTOBER 6

CARDIOLOGY TESFE M.D.,SIMRET OCTOBER 8

--===== If...

His "Quirky Update" works like a charm. Thanx.

Thanx.

Thanx for your help.