Search results

Count Dates within Date Range Problem. Hello, I have the following query that I need some assistance with. SELECT [LastName] & ", " & [FirstName] AS [Student Name], Count(tblAttendance.AttendanceDate) AS Attendance, GetDays([Enter Start Date],[Enter End Date],"46") AS [Total Classes]...

This time I read your 1st reply with both eyes open and actually saw what you did. To test the revised function I entered the following into the immediate window and got the desired result. ? GetDays ("01-Jan-2009","31-Mar-2009","46") 25 Thanks so much. Chris

Thanks for the response but unfortunately I need more detailed information. How would I go about changing the Function? Regards, Chris

Hello, I'm using the following code to calculate the number of Monday's and Wednesday's in a selected month. Public Function GetWeekDays(pmoyr As String, pdays As String) As Integer '************************************************ 'Purpose: Compute number of weekdays ' in the...

After I posted this topic I changed my query to the following. SELECT [LastName] & ", " & [FirstName] AS [Student Name], Format([AttendanceDate],"mmmm") AS AttMonth, Count(tblAttendance.AttendanceDate) AS Attendance, Format([AttendanceDate],"mm") AS SortMonth, GetWeekDays([Enter the Date],"46")...

Hello, I have an attendance report that displays student names, count of attendance for the month and the attendance percent. See the attached pdf. Currently the report will display the data for every month but that will inevitably make for a very long report. What I would like to do is only...

Hi Bob, Just wondering if anything further was happening with this. I saw your previous posts and noted that you were making some progress but haven't seen a response from you in awhile. Chris

Glad to hear that this helped resolve your problem. Thanks for posting back. Chris

I ran into this issue and found the following information on Microsoft's site that resolved it. Microsoft Office 2003 To resolve this problem in Microsoft Office 2003, follow these steps. 1. Click Start, point to Settings, click Control Panel, and then double-click Add/Remove Programs. 2...

Hi Bob, Here is a revised test.mdb. I removed all of the inactive members and added the ClassTypes table. The class types will tell you who trains when. Member Type ID Member Type 21 Junior/Youth/Adult Orange - Purple Belt - Trains Wed, Fri 44 Junior/Youth/Adult White - Yellow Belt - Trains...

Hi Bob, Here is the test database. Thanks, Chris

Hi Bob, Just curious if you had an opportunity to checkout the attached files? Did you have any comments or questions? Thanks and regards, Chris

Glad to hear that it worked for you. Thanks for posting back. Chris

Hi Kwin, Unfortunately, I have never played with what you're attempting and I'm not sure how to do it. I did some digging and found the following link for a similar question. http://help.lockergnome.com/office2/data-show-ftopict712036.html I'm running Access 2003 and I tried the 2 suggestions...

Hi Kwin, This is what I have in one of my report's No Data event. Private Sub Report_NoData(Cancel As Integer) ' Display a message if there are no receipts to be printed ' and don't preview or print report. Dim strMsg As String, strTitle As String Dim intStyle As Integer...

Hi Bob, Here it is. Chris

Hello Bob, I've tested this code and it works perfectly, thank you. I have a database for my Karate School that I use to track student's personal, grading and payment information. For my student attendance I have a report that I print off at the beginning of each month. The zip file contains...

Thanks Bob, I definitely like having another option that your code offers. I tested it and it works great. I did have a question. In the comments you noted the following. 'Inputs: 1) ? GetWeekdays("02/2008", "2") 'count Mondays ' 2) ? GetWkdays("07/2008", "246") 'count Mondays...

That worked great Brian. Thank you. When I added your expression to a query I had to group on AVG to get a single count of 5. When I didn't do this I ended up with multiple rows each displaying 5. Was grouping on AVG correct? Chris

Thanks Brian, Unfortunately I can't get it to work. Would you be able to provide a sample database? Chris