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