Re: Sorting by date in a report
- From: "John Spencer" <spencer@xxxxxxxxx>
- Date: Fri, 23 Jun 2006 08:32:47 -0400
Do you mean SORT or do you mean SELECT? Your posted code SELECTS a group of
records and has nothing to do with the order the records are sorted (display
order).
If you mean SELECT, then all you need to do is change StrWhere so it doesn't
include the [Associate] criteria.
strWhere = "[Call Date] BETWEEN #" & Me.FromDate & "# AND #" & Me.ToDate &
"#"
"Paul M" <PaulM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CDFC3A91-5154-4392-8F99-6A26E2B6A11F@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: Automation of a mail merge in access 2003
- Next by Date: Re: Using For...Each loops when referencing reports.
- Previous by thread: Re: Sorting by date in a report
- Next by thread: Re: Populating fields in a form
- Index(es):
