Predefined Queries as Building Blocks.
Pick
a Query. (Note the Banner Table names are used for our Predefined Query
Names.)
Need a list of Employees by Age?
Link the Queries and Pick the Columns
(Fields) to Include.
I usually run the New Query at this point
to see if I am on the right track.
You just need to Eliminate a few Columns, Sort the New Query, maybe Hide the Sort_Last (name) and Save it.
Oh, and that Age Query. It includes the Revised Banner Age Calculation that increments your age on your birthday instead of the day after. (Seems reasonable:)
Disclaimer
Use this information and these scripts at your own risk. As a condition of using these
scripts and information from this site, you agree to hold harmless both the
University of Arkansas Cooperative Extension Service and Bruce Knox for any
problems that they may cause or other situations that may arise from their use,
and that neither the Extension Service nor I will be held liable for those
consequences. The scripts and
information are provided "as is" without warranty, implied or
otherwise. Limitation of liability will
be the amount paid to the University of Arkansas specifically for this
information. (It was free:)
visits
http://www.uaex.edu/bknox/Summit_2003_p05.htm Predefined Queries as Building Blocks.