Like "*" & "/" & [Forms]![F_DC_Birthday]![ComboBdayMonth] & "/" & "*"
I have a form called F_DC_Birthday with combo box called ComboBdayMonth. The combo takes information from T_Month table, where I only have two field, first field is the name of Month (eg, January, February...etc) and second field is 01 to 12. The code I use in form is as below:
[HTML]Private Sub btn_RptBirthdayDC_Click()
On Error GoTo Err_btn_RptBirthdayDC_Click
Dim stDocName As String
stDocName = "Rpt_Birthday_DC"
DoCmd.OpenReport stDocName, acPreview
Exit_btn_RptBirthdayDC_Click:
Exit Sub
Err_btn_RptBirthdayDC_Click:
MsgBox Err.Description
Resume Exit_btn_RptBirthdayDC_Click
End Sub[/HTML]
I can get report of clients who have birthday on particular month that I choose from the form, however, I need the report to sort clients according to the day. In report called Rpt_Birthday_DC, I had set Sorting and Grouping of the DateOfBirth to Ascending. It sort by the year follow by the month and then day.
20/10/1920The result that I want to get is like below:
15/10/1932
28/10/1945
01/10/1950
01/10/1950Where and how to sort the date by day? Can someone guide me thru? many thanks
15/10/1932
20/10/1920
28/10/1945