G
Guest
I thought I was done (sorry guys), but now I have been given another task....
before I asked for help in sorting "Associates" and "Dates" and now I have
been given a new task to make a button sort by just the date for all
Associates.
this is the cdoe I have for the other button
Dim strWhere As String
strWhere = "[Associate] = '" & Me.cboAssociate & _
"' AND [Call Date] BETWEEN #" & Me.FromDate & "# AND #" & _
Me.ToDate & "#"
DoCmd.OpenReport "Associate Appointment Listing", acViewNormal, , strWhere
DoCmd.Close
Same Report this time I just need to sort by date, thanks in advance
before I asked for help in sorting "Associates" and "Dates" and now I have
been given a new task to make a button sort by just the date for all
Associates.
this is the cdoe I have for the other button
Dim strWhere As String
strWhere = "[Associate] = '" & Me.cboAssociate & _
"' AND [Call Date] BETWEEN #" & Me.FromDate & "# AND #" & _
Me.ToDate & "#"
DoCmd.OpenReport "Associate Appointment Listing", acViewNormal, , strWhere
DoCmd.Close
Same Report this time I just need to sort by date, thanks in advance