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
>
Tidak ada komentar:
Posting Komentar