Katrina-
Change your date sort to "from newest to oldest".
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ka0t1c_ang3l
Sent: Thursday, August 16, 2012 5:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Help with date field sort
John -
This had been working; however, when I add dates to items that have "No" in the
agenda scheduled field, it does not sort them before those items that do not
have dates. I have uploaded the database for your review in assistance needed,
and the file is labled senior staff action requests.
Your help is greatly appreciated!!
Thanks!
Katrina
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Katrina-
>
> Do you mean the Agenda Items report? Simply go into Sorting and Grouping and
> add a sort on the Agenda Scheduled field descending (Z to A) and put that
ahead
> of the sort on date.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ka0t1c_ang3l
> Sent: Wednesday, July 25, 2012 6:09 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Help with date field sort
>
> Hello all!
>
> I have created a database for staff tasks and agenda items. In my database I
> have a report for agenda items that i PDF and send to department managers.
What
> I would like to do is have those agenda items that have already been scheduled
> and have a date filled in to be displayed first in ascending order, and the
> agenda items that have not yet been scheduled and do not have a date filled in
> yet to appear afterwards in ascending order based on the item name. Is it
> possible to do this, and if so, how do I go about having my report sorted this
> way?
>
> I have uploaded my database in the Assistance Needed folder under Senior Staff
> Action Requests.
>
> Any help is greatly appreciated!
>
> Thanks!
>
> Katrina
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar